요구사항
테이블 (7)
Board (Untitled3)
- b_no (Key) — 기본 키 — NOT NULL
- user_id (Key2) — String — 외래 키 → User.user_id — NOT NULL
- title (Field)
- author (Field2)
- created_at (Field3)
- modified_at (Field4)
- deleted_at (Field5)
- like_count (Field6)
- dislike_count (Field7)
- view_count (Field8)
Board_like (Untitled5)
- id (Key3) — 기본 키 — NOT NULL
- user_id (Key4) — String — 외래 키 → User.user_id — NOT NULL
- like (Field)
- dislike (Field2)
- created_at (Field3)
- user_id (Key22) — String — NOT NULL
- b_no (Key) — 외래 키 → Board.b_no — NOT NULL
- user_id (Key2) — String — 외래 키 → Board.user_id — NOT NULL
Content (Untitled2)
- c_no (Key) — 기본 키 — NOT NULL
- b_no (Key2) — 외래 키 → Board.b_no — NOT NULL
- user_id (Key3) — String — 외래 키 → Board.user_id — NOT NULL
- text (Field)
User (Untitled)
- user_id (Key) — String — 기본 키 — NOT NULL
- Password (Field) — String
- is_active (Field2) — Bool
- Email (Field3) — String
- nickname (Field4) — String
- auth_YN (Field5) — bool
UserProfile (Untitled7)
- user_id (Key) — String — 외래 키 → User.user_id — NOT NULL
- profile_img (Field2)
- introduction (Field)
- level (Field3)
- birthday (Field4)
reply (Untitled4)
- r_no (Key) — 기본 키 — NOT NULL
- b_no (Key2) — 외래 키 → Board.b_no — NOT NULL
- user_id (Key3) — String — 외래 키 → Board.user_id — NOT NULL
- content (Field)
- created_at (Field2)
- modified_at (Field3)
- deleted_at (Field4)
- parent_no (Field5)
- depth (Field6)
reply_like (Untitled6)
- user_id (Key4) — String — 외래 키 → User.user_id — NOT NULL
- r_no (Key2) — 외래 키 → reply.r_no — NOT NULL
- b_no (Key3) — 외래 키 → reply.b_no — NOT NULL
- dislike (Field2)
- like (Field)