COCOSESON2

Tables (7)

BOARD

  • BOARD_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — VARCHAR2(100) — Foreign key → MEMBER.MEMBER_ID — 상품ID
  • TITLE — VARCHAR2(255)
  • CONTENT — CLOB
  • HIT_NO — NUMBER(4)
  • REG_DATE — DATE
  • REPLY_GROUP — NUMBER(5)
  • REPLY_ORDER — NUMBER(5)
  • REPLY_INDENT — NUMBER(5)

MEMBER

  • MEMBER_ID — VARCHAR2(100) — Primary key — 상품ID
  • ROLE_ID — VARCHAR2(20) — Foreign key → ROLE.ROLE_ID — NOT NULL
  • PASSWORD — VARCHAR2(100)
  • EMAIL — VARCHAR2(100)
  • REG_DATE — DATE
  • ADDRESS — VARCHAR2(100)
  • PHONE — VARCHAR2(100)
  • NAME — VARCHAR2(100)

ORDER_INFO

  • ORDER_ID — NUMBER — Primary key
  • PRODUCT_ID — NUMBER
  • MEMBER_ID — VARCHAR2(100)
  • PRODUCT_NAME — VARCHAR2(100)
  • UNIT_PRICE — NUMBER
  • QUANTITY — NUMBER
  • ADDRESS — VARCHAR2(100)
  • PHONE — VARCHAR2(100)

PRODUCT

  • PRODUCT_ID — NUMBER — Primary key — NOT NULL
  • NAME — VARCHAR2(100)
  • DESCRIPTION — VARCHAR2(1000)
  • UNIT_PRICE — NUMBER(10)
  • REG_DATE — DATE

PROD_IMG

  • IMG_ID — NUMBER — Primary key — NOT NULL
  • PRODUCT_ID — NUMBER — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • IMG_PATH — VARCHAR2(500)
  • FILE_NAME — VARCHAR2(500)
  • IS_MAIN — NUMBER(1)

ROLE

  • ROLE_ID — VARCHAR2(20) — Primary key — NOT NULL
  • ROLE_NAME — VARCHAR2(20)

SHOPPING_CART

  • SP_CART_ID — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — VARCHAR2(100) — Foreign key → MEMBER.MEMBER_ID — 상품ID
  • PRODUCT_ID — NUMBER — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • PRODUCT_NAME — VARCHAR2(100)
  • UNIT_PRICE — NUMBER
  • QUANTITY — NUMBER