testver

Tables (5)

ORDERS

  • ORDER_ID — NUMBER(10) — Primary key — NOT NULL
  • USER_NO — NUMBER(8) — NOT NULL
  • ADDRESS_ID — NUMBER(8) — NOT NULL
  • ORDER_DATE — DATE — NOT NULL
  • TOTAL_AMOUNT — NUMBER(10) — NOT NULL
  • STATUS — VARCHAR2(20) — NOT NULL
  • PAYMENT_METHOD — VARCHAR2(20) — NOT NULL

ORDER_DETAIL

  • DETAIL_ID — NUMBER(10) — Primary key — NOT NULL
  • ORDER_ID — NUMBER(10) — NOT NULL
  • PROD_ID — NUMBER(8) — NOT NULL
  • QUANTITY — NUMBER(5) — NOT NULL
  • PRICE — NUMBER(10) — NOT NULL

PRODUCT

  • PROD_ID — NUMBER(8) — Primary key — NOT NULL
  • NAME — VARCHAR2(300) — NOT NULL
  • DESCRIPTION — VARCHAR2(3000)
  • PRICE — NUMBER(10) — NOT NULL

USER_ADDRESS

  • ADDRESS_ID — NUMBER(8) — Primary key — NOT NULL
  • USER_NO — NUMBER(8) — NOT NULL
  • ADDRESS — VARCHAR2(200) — NOT NULL
  • MESSAGE — VARCHAR2(200)
  • RECIPIENT_NAME — VARCHAR2(50) — NOT NULL
  • RECIPIENT_PHONE — VARCHAR2(15) — NOT NULL

USER_INFO

  • USER_NO — NUMBER(8) — Primary key — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • PHONE_NUMBER — VARCHAR2(15) — NOT NULL