SellingCommunity_ERD

Tables (8)

Comment (Untitled3)

  • id (식별키) — INT — Primary key — NOT NULL
  • content (내용) — TEXT
  • user_id (댓글작성 유저) — int — Foreign key → user.id — NOT NULL
  • post_id (커뮤니티 게시글 댓글) — INT — Foreign key → Community.id — NOT NULL
  • post_id (판매 게시글 댓글) — INT — Foreign key → Product.id — NOT NULL
  • origin_id (대댓글의 부모 댓글) — INT — Foreign key → Comment.id — NOT NULL

Community (Untitled2)

  • id (식별키) — INT — Primary key — NOT NULL
  • title (제목) — VARCHAR
  • content (내용) — TEXT
  • image_url (사진정보) — VARCHAR
  • user_id (작성유저) — int — Foreign key → user.id — NOT NULL

Follow (Untitled7)

  • id (식별키) — INT — Primary key — NOT NULL
  • Field
  • following_id (팔로잉하는 유저) — int — Foreign key → user.id — NOT NULL
  • follow_id (팔로우하는 유저) — int — Foreign key → user.id — NOT NULL

Like (Untitled5)

  • id (식별키) — INT — Primary key — NOT NULL
  • user_id (좋아요 누른 유저) — int — Foreign key → user.id — NOT NULL
  • post_id (커뮤니티 게시글 좋아요) — INT — Foreign key → Community.id — NOT NULL
  • post_id (판매 게시글 좋아요) — INT — Foreign key → Product.id — NOT NULL

Product (Untitled4)

  • id (식별키) — INT — Primary key — NOT NULL
  • title (제목) — VARCHAR
  • content (내용) — TEXT
  • price (가격) — INT
  • photo_url (사진정보) — VARCHAR
  • user_id (작성유저) — int — Foreign key → user.id — NOT NULL

Purchase (Untitled6)

  • id (식별키) — INT — Primary key — NOT NULL
  • purchase_date (구매 날짜) — DATETIME
  • quantity (구매수량) — INT
  • user_id (구매한 유저) — int — Foreign key → user.id — NOT NULL
  • product_id (구매한 게시글) — INT — Foreign key → Product.id — NOT NULL

address (Untitled8)

  • id (식별키) — INT — Primary key — NOT NULL
  • state (도) — VARCHAR
  • city (시) — VARCHAR
  • district (구) — VARCHAR

user (Untitled)

  • id (식별키) — int — Primary key — NOT NULL
  • user_id (아이디) — VARCHAR
  • user_pw (비밀번호) — VARCHAR
  • name (이름) — VARCHAR
  • age (나이) — INT
  • address_detail (상세주소) — VARCHAR
  • address_id (주소) — INT — Foreign key → address.id — NOT NULL