p2p deal
Tables (6)
Bookmark (북마크)
- id (bookmark_id) — BIGINT — Primary key — NOT NULL
- 멤버 (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- 아이템 (item_id) — BIGINT — Foreign key → Item.id — NOT NULL
Category (카테고리)
- id (category_id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — CHARACTERS
Comment (댓글)
- id (comment_id) — BIGINT — Primary key — NOT NULL
- 멤버 (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- 아이템 (item_id) — BIGINT — Foreign key → Item.id — NOT NULL
- 내용 (content) — CHARACTERS
- 생성날짜 (created_at) — TIMESTAMP
- 수정날짜 (updated_at) — TIMESTAMP
Item (상품)
- id (item_id) — BIGINT — Primary key — NOT NULL
- 소유 멤버 (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- 이름 (name) — CHARACTERS
- 제품 설명 (description) — CHARACTERS
- 가격 (price) — BIGINT
- 판매 상태 (status) — CHARACTERS
- 이미지 경로 (img_path) — CHARACTERS
- 생성날짜 (created_at) — TIMESTAMP
- 수정날짜 (last_modified_at) — TIMESTAMP
Item_Category (아이템_카테고리)
- id (category_id) — BIGINT — Primary key — NOT NULL
- 아이템 (item_id) — BIGINT — Foreign key → Item.id — NOT NULL
- 카테고리 (category_id2) — BIGINT — Foreign key → Category.id — NOT NULL
Member (사용자)
- id (member_id) — BIGINT — Primary key — NOT NULL
- 이메일 (email) — CHARACTERS
- 비밀번호 (password) — CHARACTERS
- 닉네임 (nickname) — CHARACTERS
- 계정상태 (status) — CHARACTERS
- 생성날짜 (created_at) — TIMESTAMP
- 수정날짜 (last_modified_at) — TIMESTAMP
- 관리자여부 (is_admin) — BOOLEAN