HGG_HGG
Tables (7)
group
- id — int — Primary key — NOT NULL
- round_id — int — Foreign key → group_round.id — NOT NULL
- leader_id — int
group_member
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- group_id — int — Foreign key → group.id — NOT NULL
group_round
- id — int — Primary key — NOT NULL
- created_at — date
- open_at — date
- close_at — date
post
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- title — varchar(300)
- content — text
- status — enum('open', 'close', 'done')
- views — int
- meeting_date — date
- created_at — date
- updated_at — date
- deleted_at — date
post_image
- id — int — Primary key — NOT NULL
- post_id — int — Foreign key → post.id — NOT NULL
- image_url — varchar(300)
post_like
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- post_id — int — Foreign key → post.id — NOT NULL
user
- id — int — Primary key — NOT NULL
- email — varchar(200)
- password — varchar(200)
- name — varchar(100)
- nickname — varchar(200)
- kakao_id — varchar(200)
- provider — varchar(200)
- profile_image — varchar(200)
- created_at — date — NOT NULL
- updated_at — date
- deleted_at — date