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