project
테이블 (5)
게시글 (threads)
- post_id (INT) — PK — 기본 키 — NOT NULL
- title (VARCHAR(30))
- contents (TEXT)
- like (INT3)
- created_at (Field2)
- updated_at (Field3)
- user_id (INT2) — FK — 외래 키 → 사용자.user_id — NOT NULL
게시글_좋아요 (thread_like)
- user_id (post_id) — 기본 키 — NOT NULL
댓글 (comments)
- comment_id (Key) — INT — 기본 키 — NOT NULL
- post_id (Field) — INT
- user_id (Field2) — INT
- created_at (Field3)
- updated_at (Field4)
댓글_좋아요 (comments_like)
- user_id (comment_id) — 기본 키 — NOT NULL
사용자 (users)
- user_id (INT) — PK — 기본 키 — NOT NULL
- email (VARCHAR(30)) — UNIQUE
- password (VARCHAR(50))
- profile_image (VARCHAR(200))
- name (VARCHAR(20))
- phone_number (VARCHAR(11)) — CHECK (CHAR_LENGTH(name) = 11)
- address (VARCHAR(100))
- created_at (Field)
- updated_at (Field2)