본부갤
테이블 (9)
Board (Untitled6)
- board_id (Key) — 기본 키 — NOT NULL
- name (Field)
- created_at (Field2)
- modified_at (Field3)
- is_deleted (Field4)
Chat (Untitled5)
- chat_id (Key) — 기본 키 — NOT NULL
- created_at (Field)
- modified_at (Field2)
- is_delted (Field3)
Comment (Untitled3)
- comment_id (Key4) — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → User.user_id — NOT NULL
- post_id (Key22) — 외래 키 → Post.post_id — NOT NULL
- content (Field)
- n_likes (Field2)
- parent_comment_id (Key42) — 외래 키 → Comment.comment_id — NOT NULL
- created_at (Field3)
- modified_at (Field4)
- is_deleted (Field5)
Like (Untitled9)
- like_id (Key3) — 기본 키 — NOT NULL
- user_id (Key) — int — 외래 키 → User.user_id — NOT NULL
- post_id (Key2) — 외래 키 → Post.post_id — NOT NULL
Message (Untitled4)
- message_id (Key4) — 기본 키 — NOT NULL
- user_id (Key) — int — 외래 키 → User.user_id — NOT NULL
- chat_id (Key2) — 외래 키 → Chat.chat_id — NOT NULL
- created_at (Field)
- modified_at (Field2)
- is_delted (Field3)
- content (Field4)
Participant (Untitled7)
- participant_id (Key) — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → User.user_id — NOT NULL
- chat_id (Key3) — 외래 키 → Chat.chat_id — NOT NULL
Post (Untitled2)
- post_id (Key2) — 기본 키 — NOT NULL
- board_id (Key) — 외래 키 → Board.board_id — NOT NULL
- user_id (Key3) — int — 외래 키 → User.user_id — NOT NULL
- title (Field)
- content (Field2)
- created_at (Field5)
- modified_at (Field6)
- deleted_at (Field7)
- images (Field3)
Scrap (Untitled8)
- scrap_id (Key3) — 기본 키 — NOT NULL
- user_id (Key) — int — 외래 키 → User.user_id — NOT NULL
- post_id (Key2) — 외래 키 → Post.post_id — NOT NULL
User (Untitled)
- user_id (Key) — int — 기본 키 — NOT NULL
- name (Field)
- type (Field2)
- start_date (Field3)
- end_date (Field4)
- 1_date (Field5)
- 2_date (Field6)
- 3_date (Field7)
- created_at (Field8)
- modified_at (Field9)
- is_deleted (Field10)
- military_number (Field11)