boarding
Tables (3)
Comment (Untitled3)
- comment_id — BIGINT — Primary key — NOT NULL
- created_date — TIMESTAMP — NOT NULL
- modified_date — TIMESTAMP — NOT NULL
- is_removed — TINYINT — NOT NULL
- post_id — BIGINT — NOT NULL
- content — CLOB — NOT NULL
- user_id (id2) — BIGINT — Foreign key → User.user_id — NOT NULL — AutoIncrement
- parent_id (comment_id2) — BIGINT — Foreign key → Comment.comment_id — NOT NULL
Post (Untitled2)
- post_id — BIGINT — Primary key — NOT NULL — autoincrement
- title — VARCHAR(255) — NOT NULL
- content — CLOB — NOT NULL
- user_id (writer_id) — BIGINT — Foreign key → User.user_id — NOT NULL — AutoIncrement
- created_date — TIMESTAMP — NOT NULL
- modifed_date (modified_date) — TIMESTAMP — NOT NULL
- file_path — VARCHAR(255)
User (Untitled)
- user_id (id) — BIGINT — Primary key — NOT NULL — AutoIncrement
- Created_date — TIMESTAMP — NOT NULL — Updatable = False
- Modified_date — TIMESTAMP — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- Role — VARCHAR(10) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- email — VARCHAR(40) — NOT NULL
- password — VARCHAR(40) — NOT NULL
- age (Field) — INT — NOT NULL
- refreshtoken (refresh_token) — varchar(1000) — NOT NULL