TEST2
Tables (4)
CUSTOMERS
- CNO — NUMBER(5) — Primary key
- CNAME — VARCHAR(10) — NOT NULL
- ADDRESS — VARCHAR(50) — NOT NULL
- EMAIL — VARCHAR(20) — NOT NULL
- PHONE — VARCHAR(20) — NOT NULL
ORDERS
- ORDERNO — NUMBER(10) — Primary key
- ORDERDATE — DATE — NOT NULL
- ADDRESS — VARCHAR(50) — NOT NULL
- PHONE — VARCHAR(20) — NOT NULL
- STATUS — VARCHAR2(20)
- 결제완료)) — NOT — NOT NULL
- CNO — NUMBER(5) — NOT NULL
- CNO (CNO2) — NUMBER(5) — Foreign key → CUSTOMERS.CNO
ORDER_DETAIL
- ORDERNO — NUMBER(5)
- PNO — NUMBER(10)
- QTY — NUMBER(5)
- COST — NUMBER(8)
PRODUCTS
- PNO — NUMBER(5)
- PNAME — VARCHAR2(20) — NOT NULL
- COST — NUMBER(8) — NOT NULL
- STOCK — NUMBER(5) — NOT NULL