당근마켓 챌린지

테이블 (5)

MEMBER

  • MEMBER_ID — BIGINT — 기본 키 — NOT NULL
  • EMAIL — VARCHAR
  • NAME — VARCHAR
  • NICKNAME — VARCHAR
  • PASSWORD — VARCHAR
  • PHONE — VARCHAR
  • PROFILE_IMAGE_URL — VARCHAR
  • CREATED_DATE (CRATED_DATE) — TIMESTAMP
  • LAST_MODIFIED_DATE — TIMESTAMP

PRODUCT

  • PRODUCT_ID — BIGINT — 기본 키 — NOT NULL
  • MEMBER_ID — BIGINT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • COMMENTS_COUNT — BIGINT
  • LIKES_COUNT — BIGINT
  • MAIN_TEXT — VARCHAR
  • NAME — VARCHAR
  • PRICE — LONG
  • PRODUCT_CATEGORYP (PRODUCT_CATEGORY) — VARCHAR
  • PRODUCT_TRADE_STATUS — VARCHAR
  • THUMBNAIL_IMAGE_URL — VARCHAR
  • CREATED_DATE — TIMESTAMP
  • LAST_MODIFIED_DATE — TIMESTAMP

Untitled (COMMENT)

  • Key (COMMENT_ID) — BIGINT — 기본 키 — NOT NULL
  • MEMBER_ID — BIGINT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • PRODUCT_ID — BIGINT — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • Field (CONTENTS) — VARCHAR
  • Field (CREATED_DATE) — TIMESTAMP
  • Field (LAST_MODIFIED_DATE) — TIMESTAMP

Untitled (PRODUCT_IMAGE)

  • Key (PRODUCT_IMAGE_ID) — BIGINT — 기본 키 — NOT NULL
  • PRODUCT_ID — BIGINT — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • Field (URL) — VARCHAR
  • Field (CREATED_DATE) — TIMESTAMP
  • Field (LAST_MODIFIED_DATE) — TIMESTAMP

Untitled (LIKES)

  • Key (LIKE_ID) — BIGINT — 기본 키 — NOT NULL
  • MEMBER_ID — BIGINT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • PRODUCT_ID — BIGINT — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • Field (CREATED_DATE) — TIMESTAMP
  • Field (LAST_MODIFIED_DATE) — TIMESTAMP