WebSVN – SmartDukaan – /trunk/PyProj/src/shop2020/model/v1/order/impl/Order.sqlite

SQLite format 3@  ÝûöñìçâÝhuustableshop2020_model_v1_order_impl_dataservice_transactionshop2020_model_v1_order_impl_dataservice_transactionCREATE TABLE shop2020_model_v1_order_impl_dataservice_transaction (
        id INTEGER NOT NULL, 
        "createdOn" TIMESTAMP, 
        expected_delivery_time TIMESTAMP, 
        status INTEGER, 
        status_message VARCHAR(100), 
        custom 


HH³huustableshop2020_model_v1_order_impl_dataservice_transactionshop2020_model_v1_order_impl_dataservice_transactionCREATE TABLE shop2020_model_v1_order_impl_dataservice_transaction (
        id INTEGER NOT NULL, 
        "createdOn" TIMESTAMP, 
        expected_delivery_time TIMESTAMP, 
        status INTEGER, 
        status_message VARCHAR(100), 
        customer_id INTEGER, 
        PRIMARY KEY (id)
)J#tableshop2020_model_v1_order_impl_dataservice_transactiontrailshop2020_model_v1_order_impl_dataservice_transactiontrailCREATE TABLE shop2020_model_v1_order_impl_dataservice_transactiontrail (
        id INTEGER NOT NULL, 
        field_changed VARCHAR(30), 
        old_value VARCHAR(30), 
        new_value VARCHAR(30), 
        description VARCHAR(100), 
        timestamp TIMESTAMP, 
        transaction_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT shop2020_model_v1_order_impl_dataservice_transactiontrail_transaction_id_fk FOREIGN KEY(transaction_id) REFERENCES shop2020_model_v1_order_impl_dataservice_transaction (id)
)

ÅÅÁ8#Yindexix_shop2020_model_v1_order_impl_dataservice_transactiontrail_transaction_idshop2020_model_v1_order_impl_dataservice_transactiontrailCREATE INDEX ix_shop2020_model_v1_order_impl_dataservice_transactiontrail_transaction_id ON shop2020_model_v1_order_impl_dataservice_transactiontrail (transaction_id)

((å$:oo#tableshop2020_model_v1_order_impl_dataservice_shipmentshop2020_model_v1_order_impl_dataservice_shipmentCREATE TABLE shop2020_model_v1_order_impl_dataservice_shipment (
        id INTEGER NOT NULL, 
        address VARCHAR(100), 
        tracking_id VARCHAR(100), 
        status INTEGER, 
        status_message VARCHAR(100), 
        shipment_time TIMESTAMP, 
        delivery_time TIMESTAMP, 
        declared_value FLOAT, 
        insurance_value FLOAT, 
        weight FLOAT, 
        airway_bill_no VARCHAR(30), 
        provider VARCHAR(30), 
        transaction_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT shop2020_model_v1_order_impl_dataservice_shipment_transaction_id_fk FOREIGN KEY(transaction_id) REFERENCES shop2020_model_v1_order_impl_dataservice_transaction (id)
)o9indexix_shop2020_model_v1_order_impl_dataservice_shipment_transaction_idshop2020_model_v1_order_impl_dataservice_shipment        CREATE INDEX ix_shop2020_model_v1_order_impl_dataservice_shipment_transaction_id ON shop2020_model_v1_order_impl_dataservice_shipment (transaction_id)


¯¯m5indexix_shop2020_model_v1_order_impl_dataservice_payment_transaction_idshop2020_model_v1_order_impl_dataservice_paymentCREATE INDEX ix_shop2020_model_v1_order_impl_dataservice_payment_transaction_id ON shop2020_model_v1_order_impl_dataservice_payment (transaction_id)NmmOtableshop2020_model_v1_order_impl_dataservice_paymentshop2020_model_v1_order_impl_dataservice_payment
CREATE TABLE shop2020_model_v1_order_impl_dataservice_payment (
        id INTEGER NOT NULL, 
        merchant_tx_id VARCHAR(30), 
        bank_tx_id VARCHAR(30), 
        amount FLOAT, 
        status INTEGER, 
        status_message VARCHAR(100), 
        start_time TIMESTAMP, 
        finish_time TIMESTAMP, 
        transaction_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT shop2020_model_v1_order_impl_dataservice_payment_transaction_id_fk FOREIGN KEY(transaction_id) REFERENCES shop2020_model_v1_order_impl_dataservice_transaction (id)
)


ÀÀ×¼m5indexix_shop2020_model_v1_order_impl_dataservice_payment_transaction_idshop2020_model_v1_order_impl_dataservice_paymentCREATE INDEX ix_shop2020_model_v1_order_impl_dataservice_payment_transaction_id ON shop2020_model_v1_order_impl_dataservice_payment (transaction_id)&mmtableshop2020_model_v1_order_impl_dataservice_billingshop2020_model_v1_order_impl_dataservice_billing
CREATE TABLE shop2020_model_v1_order_impl_dataservice_billing (
        id INTEGER NOT NULL, 
        bill_number VARCHAR(30), 
        created_on TIMESTAMP, 
        generated_by VARCHAR(30), 
        PRIMARY KEY (id)
)

¬¬Q     ooQtableshop2020_model_v1_order_impl_dataservice_lineitemshop2020_model_v1_order_impl_dataservice_lineitemCREATE TABLE shop2020_model_v1_order_impl_dataservice_lineitem (
        id INTEGER NOT NULL, 
        added_on TIMESTAMP, 
        item_id INTEGER, 
        transaction_id INTEGER, 
        billing_id INTEGER, 
        shipment_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT shop2020_model_v1_order_impl_dataservice_lineitem_transaction_id_fk FOREIGN KEY(transaction_id) REFERENCES shop2020_model_v1_order_impl_dataservice_transaction (id), 
         CONSTRAINT shop2020_model_v1_order_impl_dataservice_lineitem_shipment_id_fk FOREIGN KEY(shipment_id) REFERENCES shop2020_model_v1_order_impl_dataservice_shipment (id), 
         CONSTRAINT shop2020_model_v1_order_impl_dataservice_lineitem_billing_id_fk FOREIGN KEY(billing_id) REFERENCES shop2020_model_v1_order_impl_dataservice_billing (id)
)

ÄÄÓåÀ
o)indexix_shop2020_model_v1_order_impl_dataservice_lineitem_billing_idshop2020_model_v1_order_impl_dataservice_lineitemCREATE INDEX ix_shop2020_model_v1_order_impl_dataservice_lineitem_billing_id ON shop2020_model_v1_order_impl_dataservice_lineitem (billing_id)
o-indexix_shop2020_model_v1_order_impl_dataservice_lineitem_shipment_idshop2020_model_v1_order_impl_dataservice_lineitemCREATE INDEX ix_shop2020_model_v1_order_impl_dataservice_lineitem_shipment_id ON shop2020_model_v1_order_impl_dataservice_lineitem (shipment_id)o9indexix_shop2020_model_v1_order_impl_dataservice_lineitem_transaction_idshop2020_model_v1_order_impl_dataservice_lineitemCREATE INDEX ix_shop2020_model_v1_order_impl_dataservice_lineitem_transaction_id ON shop2020_model_v1_order_impl_dataservice_lineitem (transaction_id)



îî*{Iindexix_shop2020_model_v1_order_impl_dataservice_additionalinfo_line_item_idshop2020_model_v1_order_impl_dataservice_additionalinfoCREATE INDEX ix_shop2020_model_v1_order_impl_dataservice_additionalinfo_line_item_id ON shop2020_model_v1_order_impl_dataservice_additionalinfo (line_item_id)b
{{[tableshop2020_model_v1_order_impl_dataservice_additionalinfoshop2020_model_v1_order_impl_dataservice_additionalinfoCREATE TABLE shop2020_model_v1_order_impl_dataservice_additionalinfo (
        id INTEGER NOT NULL, 
        "key" VARCHAR(30), 
        value VARCHAR(100), 
        line_item_id INTEGER, 
        PRIMARY KEY (id), 
         CONSTRAINT shop2020_model_v1_order_impl_dataservice_additionalinfo_line_item_id_fk FOREIGN KEY(line_item_id) REFERENCES shop2020_model_v1_order_impl_dataservice_lineitem (id)
)
Subversion Repositories SmartDukaan

(root)/trunk/PyProj/src/shop2020/model/v1/order/impl/Order.sqlite @ 115 – Rev
