갠프 관리자 erd
테이블 (4)
CATEGORIES
- CAT_ID — VARCHAR2(30) — 기본 키
- CAT_NAME — VARCHAR(30)
ORDERS
- ORDER_ID — VARCHAR2(10)
- USER_NAME — VARCHAR2(30)
- PROD_NAME — VARCHAR(30) — NOT NULL
- ORDER_DATE — DATE
- TOTAL_PRICE — NUMBER(10)
- ADDRESS — VARCHAR2(300)
- STATUS — VARCHAR2(50)
PRODUCTS
- PROD_ID — VARCHAR2(10)
- PROD_NAME — VARCHAR2(30)
- PROD_DESCRIPTION — VARCHAR2(1000)
- PROD_PRICE — NUMBER(10)
- PROD_STOCK — NUMBER(3)
- CAT_ID — VARCHAR2(30) — 외래 키 → CATEGORIES.CAT_ID
USERS
- USER_ID — VARCHAR2(10) — 기본 키
- USER_NAME — VARCHAR(30)
- USER_PW — VARCHAR2(30)
- USER_AGE — NUMBER(3)
- ADDRESS — VARCHAR2(1000)
- D_ADDRESS — VARCHAR(1000)
- PHONE — VARCHAR2(14)
- CREATE_DATE — DATE