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