homepage
Tables (4)
comment_table (COMMENT_TABLE)
- IDX (idx) — Primary key — NOT NULL
- POST_IDX (post_idx) — Foreign key → post_table.IDX — NOT NULL
- USER_IDX (user_idx) — int — Foreign key → post_table.USER_IDX — NOT NULL
- CONTENT (content)
- DEPTH (depth) — int
- UPLOAD_TIME (upload_time)
- UPDATE_TIME (update_time)
- DELETE_TIME (delete_time)
like_table (LIKE_TABLE)
- IDX (idx) — Primary key — NOT NULL
- POST_LIKE (post_like)
- COMMENT_LIKE (comment_like)
- Field3
- Field4
post_table (POST_TABLE)
- IDX (idx) — Primary key — NOT NULL
- USER_IDX (user_idx) — int — Foreign key → user_table.idx — NOT NULL
- CONTENT (content)
- PASSWORD (password)
- UPLOAD_TIME (upload_time)
- UPDATE_TIME (update_time)
- DELETE_TIME (delete_time)
user_table (USER_TABLE)
- idx — int — Primary key — NOT NULL
- ID (id) — varchar(20)
- Password (password) — varchar(255)
- NAME (name) — varchar(20)
- EMAIL (email) — varchar(100)
- PHONE_NUM (phone_num) — varchar(100)
- Field6 — DATE
- UPDATE_TIME (update_time) — DATE
- RESIGN_TIME (resign_time) — DATE
- SALT (salt) — int