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)