member

Tables (8)

AUTHOR (Untitled5)

  • AUTHOR_ID Char(20) NN (Key) — Primary key — NOT NULL
  • AUTHOR_NM Char(20) (Field)
  • AUTHOR_TELNO Char(24) NN (Field2)
  • GENRE Char(20) NN (Field3)
  • AUTHOR_ADDR Char(120) NN (Field4)

BOOK (Untitled6)

  • PRODUCT_CODE Char(30) NN (Key) — Primary key — NOT NULL
  • PRODUCT_AMT Char(12) NN (Field)
  • PRODUCT_GENRE Char(20) NN (Field2)
  • BOOK_PRICE Char(30) NN (Field3)
  • PUB_DATE DateTime (Field4)
  • PUBLISHER_NM Char(40) NN (Field5)
  • AUTHOR_NM Char(12) NN (Field6)
  • ORD_NUM Char(20) (Key2) — Foreign key → ORDER.ORD_NUM Char(20) — NOT NULL
  • DELIEV_NO Char(20) NN (Key22) — Foreign key → ORDER.DELIEV_NO Char(20) NN — NOT NULL
  • AUTHOR_ID Char(20) NN (Key3) — Foreign key → AUTHOR.AUTHOR_ID Char(20) NN — NOT NULL
  • WAREHOUSE_CD Char(12) NN (Key4) — Foreign key → WAREHOUSE.WAREHOUSE_CD Char(12) NN — NOT NULL

DELIEV (Untitled4)

  • DELIEV_NO CHAR(20) NN (Key) — Primary key — NOT NULL
  • DELIEV_DATE DateTime NN (Field)
  • DELIEV_ADDR Char(120) NN (Field2)
  • DELIEV_CP Char(20) NN (Key2) — Foreign key → DELIEV_CP.DELIEV_CP_BN Char(20) NN — NOT NULL

DELIEV_CP (Untitled3)

  • DELIEV_CP_BN Char(20) NN (Key) — Primary key — NOT NULL
  • DELIEV_CP_NM Char(40) NN (Field)
  • DELIEV_CP_TELNO Char(20) NN (Field2)
  • DELIEV_CP_ADDR Char(120) NN (Field3)
  • ACCOUNT_NO Char(30) NN (Field4)
  • DEPOSITOR Char(50) NN (Field5)

Member (Untitled)

  • MeberID Char(20) NN (PK) — Primary key — NOT NULL
  • REG_NUM Char(20) NN (Field)
  • PHONE_NUM Char(20) (Field2)
  • BIRTH char(12) (Field3)
  • ADDR Char(120) NN (Field4)
  • EPOINTS Integer (Field5)
  • PW Char(12) NN (Field6)
  • EMAIL Char(50) (Field7)

ORDER (Untitled2)

  • ORD_NUM Char(20) (Key) — Primary key — NOT NULL
  • DELIEV_NO Char(20) NN (Key2) — Primary key — NOT NULL
  • ORDER__DATE DateTime NN (Field)
  • DELIEV_ADDR Char(120) NN (Field2)
  • PAY_METHOD Char(12) NN (Field3)
  • SHOP_BASKET Char(120) (Field4)
  • MeberID Char(20) NN (PK) — Foreign key → Member.MeberID Char(20) NN — NOT NULL
  • DELIEV_NO CHAR(20) NN (Key3) — Foreign key → DELIEV.DELIEV_NO CHAR(20) NN — NOT NULL

PUBLISHER (Untitled8)

  • PUBLISHER_NO Char(20) NN (Key) — Primary key — NOT NULL
  • CONTRACT_DATE DateTime (Field)
  • PUBLISHER_LOC Char(120) NN (Field2)
  • AUTHOR_ID Char(20) NN (Key2) — Foreign key → AUTHOR.AUTHOR_ID Char(20) NN — NOT NULL

WAREHOUSE (Untitled7)

  • WAREHOUSE_CD Char(12) NN (Key) — Primary key — NOT NULL
  • WAREHOUSE_LOC Char(120) NN (Field)
  • BOOK_STOCK Char(30) NN (Field2)
  • WAREHOUSE_TELNO Char(20) (Field3)