lifegram
Tables (4)
Comment (Untitled3)
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
- FK (post_id) — BIGINT — Foreign key → Post.PK — NOT NULL
- 댓글내용 (content) — VARCHAR(256)
- 생성 (created_at) — TIMESTAMP
- 업데이트 (updated_at) — TIMESTAMP
Like (Untitled4)
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
- FK (post_id) — BIGINT — Foreign key → Post.PK — NOT NULL
Post (Untitled2)
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
- 내용 (content) — VARCHAR(1024)
- 이미지URL (img_url) — VARCHAR(255)
- 생성 (created_at) — TIMESTAMP
- 업데이트 (updated_at) — TIMESTAMP
User (Untitled)
- PK (id) — BIGINT — Primary key — NOT NULL
- 유저이름 (user_name) — VARCHAR(32)
- 이메일 (email) — VARCHAR(256)
- 패스워드 (password) — VARCHAR(256)
- 이미지URL (img_url) — VARCHAR(256)
- 생성 (created_at) — TIMESTAMP
- 업데이트 (updated_at) — TIMESTAMP