Basic data structure of the purchase part

xiaoxiao2021-03-06  20

There is a primary information indicating the primary table, MR_ORDERS, putting the list, such as the basic state, name, type of the list.

There are three states in the list, the price list, the quotation, and the price list are all stored in the MR_ORDER standard.

There is a field inside the price list, called ORDER_NUMBER, which can be unique to determine which single child is.

There is also a parent_order_number, through him, the quotation can find the value of the price he corresponds, but also find the quotation he corresponds to him.

MR_ORDERS has a primary key, which is OID, he as the foreign key of the other three from the table.

There are three from the table here, MR_RFQ_Supplier

OID ---- pointing to the primary key OID inside MR_ORDERS,

Supplier_acct_id ------ pointing to OID in the unit table

Supplier_user_id ------ pointing to OID in the user table

RFQ_Item_idx --------- 0, 1, 2, 3 indicates his location inside the entire list.

转载请注明原文地址:https://www.9cbs.com/read-42485.html

New Post(0)