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