123
Tables (4)
Comment
- id — BIGINT
- post_id — BIGINT — Foreign key → Post.id — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
- contents — VARCHAR(255) — NOT NULL
- reg_date — TIMESTAMP
- update_date — TIMESTAMP
Post
- id — BIGINT
- title — VARCHAR(255)
- contents — VARCHAR(255)
- writer — VARCHAR(255)
- hits — INTEGER
- likes — INTEGER
- reg_date — TIMESTAMP
- update_date — TIMESTAMP
- deleted_date — TIMESTAMP
- deleted — BOOLEAN
- user_id — BIGINT — Foreign key → User.id
Post_Like
- id — BIGINT
- post_id — BIGINT — Foreign key → Post.id
- user_id — BIGINT — Foreign key → User.id — NOT NULL
- like_date — TIMESTAMP
User
- id — BIGINT
- email — VARCHAR(255)
- user_name — VARCHAR(255)
- password — VARCHAR(255)
- phone — VARCHAR(255)
- reg_date — TIMESTAMP
- update_date — TIMESTAMP