클론코딩(marketkurly)
테이블 (4)
CART
- ID (CART_ID) — BIGINT() — 기본 키 — NOT NULL
- TITLE (PRODUCT_TITLE) — VARCHAR(255)
- IMG_URL (PRODUCT_IMG_URL) — VARCHAR(1000)
- PRICE (PRODUCT_PRICE) — VARCHAR(255)
- SUM (PRODUCT_PRICE_SUM) — VARCHAR(255)
- ADRESS (USER_ADRESS) — VARCHAR(255)
- ID (USER_ID) — BIGINT() — 외래 키 → USER.ID — NOT NULL
- ID (PRODUCT_ID2) — BIGINT() — 외래 키 → PRODUCT.ID — NOT NULL
PRODUCT
- ID (PRODUCT_ID) — BIGINT() — 기본 키 — NOT NULL
- TITLE — VARCHAR(255)
- IMG_URL — VARCHAR(1000)
- PRICE (PRODUCT_PRICE) — VARCHAR(255)
- PRODUCT_DETAIL — VARCHAR(255)
- COMMENT (REVIEW_COMMENT) — VARCHAR(255)
REVIEW
- ID (COMMENT_ID) — BIGINT() — 기본 키 — NOT NULL
- ID (USER_ID) — BIGINT() — 외래 키 → USER.ID — NOT NULL
- ID (PRODUCT_ID) — BIGINT() — 외래 키 → PRODUCT.ID — NOT NULL
- NICKNAME (USER_NICKNAME) — VARCHAR(255)
- COMMENT (REVIEW_COMMENT) — VARCHAR(255)
- CREATED_AT — TIMESTAMP()
- MODIFIED_AT — TIMESTAMP()
USER
- ID (USER_ID) — BIGINT() — 기본 키 — NOT NULL
- USERNAME — VARCHAR(255)
- PASSWORD — VARCHAR(255)
- NICKNAME (USER_NICKNAME) — VARCHAR(255)
- Field