SQLD2
Tables (6)
CONTENTS
- CONTENTS_UID — NUMBER — Primary key — NOT NULL
- CONTENTS_NAME — VARCHAR2(150)
INVENTORY MANAGEMENT
- INVENTORY MANAGEMENT_UID — NUMBER — Primary key — NOT NULL
- INVENTORY MANAGEMENT_NAME — VARCHAR2(150)
- INVENTORY MANAGEMENT_QNT — NUMBER
PAY MENT
- PAY MENT_UID — NUMBER — Primary key — NOT NULL
- PAY MENT_NAME — VARCHAR2(200)
PRODUCT
- PRODUCT_UID — NUMBER — Primary key — NOT NULL
- PRODUCTTYPE_UID — NUMBER — Foreign key → PRODUCT TYPE.PRODUCTTYPE_UID — NOT NULL
- UESR_UID — NUMBER — Foreign key → UESR.UESR_UID — NOT NULL
- CONTENTS_UID — NUMBER — Foreign key → CONTENTS.CONTENTS_UID — NOT NULL
- INVENTORY MANAGEMENT_UID — NUMBER — Foreign key → INVENTORY MANAGEMENT.INVENTORY MANAGEMENT_UID — NOT NULL
- PAY MENT_UID — NUMBER — Foreign key → PAY MENT.PAY MENT_UID — NOT NULL
- PRODUCT_NAME — VARCHAR2(150)
- PRODUCT_PRICE — NUMBER
- PRODUCT_SALES_PRICE — NUMBER
- PRODUCT_DESSCRIPTION — VARCHAR2(200) — 설명
- PRODUCT_QNT — NUMBER
PRODUCT TYPE
- PRODUCTTYPE_UID — NUMBER — Primary key — NOT NULL
- PRODUCTTYPE_NAME — VARCHAR2(150)
UESR
- UESR_UID — NUMBER — Primary key — NOT NULL
- UESR_ID — VARCHAR2(150)
- UESR_PASSWORD — VARCHAR2(150)
- UESR_SEX — VARCHAR2(50)
- UESR_BIRTH — VARCHAR2(100)
- UESR_NAME — VARCHAR2(150)
- UESR_MOBILE — NUMBER
- UESR_ZIPCODE — NUMBER
- UESR_ADD1 — VARCHAR2(150)
- UESR_ADD2 — VARCHAR2(150)
- UESR_COMMENT — VARCHAR2(200)