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