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