asd
Tables (7)
album
- id — bigint — Primary key — NOT NULL
- post_id — bigint — Foreign key → post.post_id — NOT NULL
- group_id (group_id2) — bigint — Foreign key → post.group_id — NOT NULL
- user_id — bigint — Foreign key → post.user_id — NOT NULL
- created_at — datetime(6)
- image_url — varchar(255) — NOT NULL
- group_id — bigint
- uploader_id — bigint — NOT NULL
comment
- comment_id — bigint — Primary key — NOT NULL
- post_id (post_id2) — bigint — Foreign key → post.post_id — NOT NULL
- group_id (group_id2) — bigint — Foreign key → post.group_id — NOT NULL
- user_id (user_id2) — bigint — Foreign key → post.user_id — NOT NULL
- content — varchar(1000) — NOT NULL
- created_at — date — NOT NULL
- user_id — bigint — NOT NULL
- post_id — bigint — NOT NULL
pgroup
- group_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- category — varchar(255) — NOT NULL
- create_at — datetime(6) — NOT NULL
- d_day — int — NOT NULL
- deadline — datetime(6)
- description — varchar(255) — NOT NULL
- groupname — varchar(255) — NOT NULL
- profile_image — varchar(255)
- owner_id — bigint
- latitude — double — NOT NULL
- longitude — double — NOT NULL
- location — varchar(255) — NOT NULL
pgroup_members
- id — bigint — Primary key — NOT NULL
- user_id (user_id2) — bigint — Foreign key → users.user_id — NOT NULL
- introduce — varchar(500)
- joined_at — date — NOT NULL
- role — enum('admin','banned','member','owner','pending') — NOT NULL
- group_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
post
- post_id — bigint — Primary key — NOT NULL
- group_id (group_id2) — bigint — Foreign key → pgroup.group_id — NOT NULL
- user_id — bigint — Foreign key → pgroup.user_id — NOT NULL
- content — varchar(5000) — NOT NULL
- created_at — date — NOT NULL
- title — varchar(255) — NOT NULL
- updated_at — date — NOT NULL
- author_id — bigint — NOT NULL
- group_id — bigint — NOT NULL
- album_image — varchar(255)
- board_image — varchar(255)
- category — varchar(255)
- image_path — varchar(255)
user_group
- group_id — int — Primary key — NOT NULL
- group_id (group_id2) — bigint — Foreign key → pgroup.group_id — NOT NULL
- user_id — bigint — Foreign key → pgroup.user_id — NOT NULL
- user_id (user_id2) — bigint — Foreign key → users.user_id — NOT NULL
- representation_id — int — NOT NULL
- post_id — int
- comment_id — int
- next_number — int
- chat_id — int
- groupname — varchar(100) — NOT NULL
- description — text
- category — varchar(50)
- location — varchar(100)
- profile_image — text
- create_at — timestamp
- deadline — timestamp
- d_day — int
users
- user_id — bigint — Primary key — NOT NULL
- created_at — date — NOT NULL
- email — varchar(50)
- login_type — enum('BOTH','EMAIL','KAKAO') — NOT NULL
- password — varchar(255)
- username — varchar(20) — NOT NULL
- latitude — double
- longitude — double
- bio — text
- interest_type — int