project22
Tables (5)
album
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- image_url — varchar(255) — NOT NULL
- group_id — bigint — NOT NULL
- uploader_id — bigint — NOT NULL
pgroup
- group_id — bigint — Primary key — 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 — NOT NULL
- latitude — double — NOT NULL
- longitude — double — NOT NULL
- location — varchar(255) — NOT NULL
pgroup_members
- id — bigint — Primary key — 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
user_group
- group_id — int — Primary key — 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