Mindbridge
Tables (8)
Answer (Untitled3)
- answer_id (Key) — Primary key — NOT NULL — 답변 고유 번호
- post_id (Key2) — Primary key — NOT NULL
- responder_id (Key3) — Primary key — NOT NULL — 답변 작성자 ID
- r_content (Key4) — Primary key — NOT NULL — 답변 내용
Bookmark (Untitled4)
- bookmark_id (Key) — Primary key — NOT NULL — 북마크 고유 번호
- user_id (Key2) — Primary key — NOT NULL — 북마크한 사용자
- post_id (Key3) — Primary key — NOT NULL — 북마크된 고민 글
Category (Untitled5)
- category_id (Key) — Primary key — NOT NULL
- category_name (Key2) — Primary key — NOT NULL
ChatMessage (Untitled7)
- message_id (Key) — Primary key — NOT NULL
- room_id (Key2) — Primary key — NOT NULL
- sended_user_id (Key3) — Primary key — NOT NULL
ChatRoom (Untitled6)
- room_id (Key) — Primary key — NOT NULL
- room_title (Key2) — Primary key — NOT NULL
- category_id (Key3) — Primary key — NOT NULL
- created_user_id (Key4) — Primary key — NOT NULL
Post (Untitled2)
- post_id (Key) — Primary key — NOT NULL — 고민 글 기본 키
- write_user_id (Key2) — Primary key — NOT NULL — 글 작성자
- title (Key3) — Primary key — NOT NULL — 고민 제목
- p_content (Key4) — Primary key — NOT NULL — 고민 내용 본문
- category_id (Key5) — Primary key — NOT NULL — 고민 글 분류
- anonymous (Key6) — Primary key — NOT NULL — 익명 글 여부
Report (Untitled8)
- report_id (Key) — Primary key — NOT NULL
- reported_user_id (Key2) — Primary key — NOT NULL
- reporter_user_id (Key3) — Primary key — NOT NULL
- target_id (Key4) — Primary key — NOT NULL
- reason (Key5) — Primary key — NOT NULL
- report_type (Key6) — Primary key — NOT NULL
User (Untitled)
- user_id (Key) — Primary key — NOT NULL
- password (Key2) — Primary key — NOT NULL
- name (Key3) — Primary key — NOT NULL
- nickname (Key4) — Primary key — NOT NULL
- gender (Key5) — Primary key — NOT NULL
- birth_year (Key6) — Primary key — NOT NULL
- profile (Key7) — Primary key — NOT NULL
- verified (Key8) — Primary key — NOT NULL