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