board
Tables (6)
comment_likes
- like_id — bigint — Primary key — NOT NULL
- comment_id — bigint
comments
- comment_id — bigint — Primary key — NOT NULL
- post_id (post_id2) — bigint — Foreign key → posts.post_id — NOT NULL
- usr_id — bigint — Foreign key → users.usr_id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- comment_content — varchar(255) — NOT NULL
likes
- like_id — bigint — Primary key — NOT NULL
- usr_id — bigint — Foreign key → users.usr_id — NOT NULL
- dtype — varchar(31) — NOT NULL
- like_status — varchar(255) — NOT NULL
post_likes
- like_id — bigint — Primary key — NOT NULL
- post_id — bigint
posts
- post_id — bigint — Primary key — NOT NULL
- usr_id (usr_id2) — bigint — Foreign key → users.usr_id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- post_content — varchar(255) — NOT NULL
- post_title — varchar(255) — NOT NULL
users
- usr_id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- usr_age — integer
- usr_email — varchar(255) — NOT NULL
- usr_hobby — varchar(255)
- usr_name — varchar(255) — NOT NULL
- usr_password — varchar(255) — NOT NULL