Concurrency Project

Tables (6)

Comment (게시글 댓글 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • id (Key3) — bigint — Foreign key → Post.id — NOT NULL
  • body (Field3) — varchar
  • create_at (Field) — datetime
  • update_at (Field2) — datetime

Like (게시글 좋아요 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • post_id (Key3) — bigint — Foreign key → Post.id — NOT NULL
  • create_at (Field) — datetime
  • update_at (Field2) — datetime

Post (게시글 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar
  • body (Field2) — varchar
  • create_at (Field3) — datetime
  • update_at (Field4) — datetime

Scrab (사용자 게시글 스크랩 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • post_id (Key3) — bigint — Foreign key → Post.id — NOT NULL
  • create_at (Field) — datetime
  • update_at (Field2) — datetime

User (사용자 테이블)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar
  • password (Field3) — varchar
  • username (Field2) — varchar
  • social_login (Field4) — enum
  • post_count (Field5) — int
  • post_scrab (Field6) — ?
  • user_inactive (Field9) — boolean
  • create_at (Field7) — datetime
  • update_at (Field8) — datetime

User_Post (사용자-글 중간 테이블)

  • Key — Primary key — NOT NULL
  • id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • id (Key3) — bigint — Foreign key → Post.id — NOT NULL