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)