thread

Tables (4)

comments

  • COMMENTID (comm_id) — UUID — Primary key — NOT NULL
  • 내용 (comm_content) — TEXT — NOT NULL
  • 생성시간 (comm_created) — TIMESTAMP — NOT NULL
  • 수정시간 (comm_updated) — TIMESTAMP
  • USERKEY (user_key) — UUID — Foreign key → users.USERKEY — NOT NULL
  • POSTID (post_id) — UUID — Foreign key → posts.POSTID — NOT NULL

likes

  • LIKEID (like_id) — UUID — Primary key — NOT NULL
  • 생성시간 (like_created) — TIMESTAMP — NOT NULL
  • POSTID (post_id) — UUID — Foreign key → posts.POSTID — NOT NULL
  • USERKEY (user_key) — UUID — Foreign key → users.USERKEY — NOT NULL

posts

  • POSTID (post_id) — UUID — Primary key — NOT NULL
  • 내용 (post_content) — TEXT — NOT NULL
  • 생성시간 (post_created) — TIMESTAMP — NOT NULL
  • 수정시간 (post_updated) — TIMESTAMP
  • USERKEY (user_key) — UUID — Foreign key → users.USERKEY — NOT NULL

users

  • USERKEY (user_key) — UUID — Primary key — NOT NULL
  • 비밀번호 (user_pw) — VARCHAR(100) — NOT NULL
  • 이름 (user_name) — VARCHAR(100) — NOT NULL
  • 전화번호 (user_phonenumber) — VARCHAR(20) — NOT NULL
  • 생성시간 (user_created) — TIMESTAMP — NOT NULL
  • ID (user_id) — VARCHAR(100) — NOT NULL