갠프 관리자 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