order
Tables (4)
CODES (公共代码)
- CD_ID (Key) — Primary key — NOT NULL
- CD_GRP_ID (Field)
- CD_INFO (Field2)
- CD_NM (Field3)
- CD_SEQ (Field4)
CODE_GROUP (公共代码组)
- CD_GRP_ID (Key) — NUM — Primary key — NOT NULL
- CD_GRP_NM (Field) — VARCHAR
- CD_GRP_INFO (Field2)
- CD_GRP_CTIME (Field3)
ORDERS (订单)
- OR_ID (Key) — NUM — Primary key — NOT NULL
- USR_ID (用户ID) — NUM — Foreign key → USERS.USR_ID — NOT NULL
- GOODS_CD (Field) — VARCHAR
- GOODS_NUM (Field2) — VARCHAR
- OR_PAY (Field3) — NUM
- OR_CTIME (Field4)
USERS (用户)
- USR_ID (用户ID) — NUM — Primary key — NOT NULL
- USR_NM (用户名) — VARCHAR
- USR_TEL (Field2) — VARCHAR
- USR_ADD (Field3) — VARCHAR
- CON_CD (Field4) — VARCHAR
- CON_INFO (Field5) — VARCHAR
- USR_CTIME (Field12) — DATE
- USR_LINK (Field) — VARCHAR