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)