Usinsa
Tables (6)
Comment (댓글)
- comment_id (CommentPK) — int — Primary key — NOT NULL
- review_id (ReviewPK) — int — Foreign key → Review.review_id — NOT NULL
- content (댓글 내용) — TEXT
- create_at (생성일시) — datetime
- user_id (UserPK) — int — Foreign key → User.user_id — NOT NULL
Comment_Like (댓글 좋아요)
- id (Key) — int — Primary key — NOT NULL
- comment_id (CommentPK) — bigint — Foreign key → Comment.comment_id — NOT NULL
- user_id (UserPK) — int — Foreign key → User.user_id — NOT NULL
Like (게시물 좋아요)
- id (Key) — int — Primary key — NOT NULL
- review_id (ReviewPK) — bigint — Foreign key → Review.review_id — NOT NULL
- product_id (ProductPK) — bigint — Foreign key → Review.product_id — NOT NULL
- user_id (UserPK) — int — Foreign key → User.user_id — NOT NULL
Product (상품)
- product_id (ProductPK) — int — Primary key — NOT NULL
- title (상품 제목) — varchar(50)
- brand (상품 브랜드) — varchar(50)
- photo (상품 사진) — varchar(255)
- data_id (상품 ID) — INTEGER
Review (게시글)
- review_id (ReviewPK) — int — Primary key — NOT NULL
- product_id (ProductPK) — int — Foreign key → Product.product_id — NOT NULL
- title (상품 제목) — varchar(50)
- brand (상품 브랜드) — varchar(50)
- photo (상품 사진) — varchar(255)
- review_product_id (상품 ID) — INTEGER
- review_title (리뷰 제목) — varchar(50)
- content (리뷰 내용) — TEXT
- review_photo (리뷰 사진) — varchar(100)
- score (평점) — INTEGER
- created_at (생성일시) — datetime
- user_id (UserPK) — int — Foreign key → User.user_id — NOT NULL
User (사용자)
- user_id (UserPK) — int — Primary key — NOT NULL
- username (사용자 이름) — varchar(150)
- password (비밀번호) — varchar(128)
- profile_image (프로필 이미지) — varchar(100)