당근마켓 챌린지
테이블 (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