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