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