momo

Tables (14)

achievement_rate

  • achievement_rate_id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • meeting_id — bigint — NOT NULL
  • attendance_cnt — int — NOT NULL

attendance

  • attendance_id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • meeting_id — bigint — NOT NULL
  • schedule_id — bigint — NOT NULL
  • attendance_flag — boolean — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp

chatroom

  • chatroom_id — bigint — Primary key — NOT NULL
  • meeting_id — bigint — NOT NULL
  • manager_id — bigint — NOT NULL
  • requester_id — bigint — NOT NULL

favorite_meeting

  • favorite_id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • meeting_id — bigint — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp

meeting

  • meeting_id — bigint — Primary key — NOT NULL
  • main_img — varchar(255)
  • manager_id — bigint — NOT NULL
  • category — varchar(255)
  • meeting_type — varchar(255) — NOT NULL
  • start_date — timestamp — NOT NULL
  • end_date — timestamp — NOT NULL
  • university — varchar(255)
  • area — varchar(255)
  • introduction — longtext — NOT NULL
  • recruitment_cnt — int — NOT NULL
  • participant_cnt — int — NOT NULL
  • schedule_cnt — int — NOT NULL
  • attendance_cnt — int — NOT NULL
  • end_flag — boolean — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp

notice

  • notice_id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • meeting_id — bigint — NOT NULL
  • title — varchar(255) — NOT NULL
  • contents — longtext — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp

notice_comment

  • notice_comment_id — bigint — Primary key — NOT NULL
  • notice_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • contents — longtext — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp

notice_img

  • notice_img_id — bigint — Primary key — NOT NULL
  • notice_id — bigint — NOT NULL
  • img_url — varchar(255) — NOT NULL

participants

  • participant_id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • meeting_id — bigint — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp

post

  • post_id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • meeting_id — bigint — NOT NULL
  • title — varchar(255) — NOT NULL
  • contents — longtext — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp

post_comment

  • post_comment_id — bigint — Primary key — NOT NULL
  • post_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • contents — longtext — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp

post_img

  • post_img_id — bigint — Primary key — NOT NULL
  • post_id — bigint — NOT NULL
  • img_url — varchar(255) — NOT NULL

schedule

  • schedule_id — bigint — Primary key — NOT NULL
  • meeting_id — bigint — NOT NULL
  • schedule_type — varchar(255) — NOT NULL
  • schedule_time — varchar(255) — NOT NULL
  • contents — varchar(255)
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp

user

  • user_id — bigint — Primary key — NOT NULL
  • identity — varchar(255) — NOT NULL
  • nickname — varchar(255)
  • profile_img — varchar(255)
  • area — varchar(255)
  • university — varchar(255)
  • favorite_category — varchar(255)
  • role — varchar(255) — NOT NULL
  • provider — varchar(255) — NOT NULL
  • created_date — timestamp — NOT NULL
  • last_modified_date — timestamp