클론코딩(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