WORKDUO
Tables (28)
exist_member
- member_email — VARCHAR(255) — Primary key — NOT NULL
group_content
- group_content_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- group_id — BIGINT — Foreign key → group_table.group_id — NOT NULL
- title — VARCHAR(30) — NOT NULL
- content — LONGTEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_yn — BIT — NOT NULL
- deleted_at — DATETIME(6)
- notice_yn — BIT — NOT NULL
- sort_value — INT — NOT NULL
group_content_comment
- group_content_comment_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- group_content_id (groupcontent_id) — BIGINT — Foreign key → group_content.group_content_id — NOT NULL
- comment — TEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted_yn — BIT — NOT NULL
group_content_comment_like
- group_content_comment_like_id — BIGINT — Primary key — NOT NULL
- group_content_comment_id — BIGINT — Foreign key → group_content_comment.group_content_comment_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
group_content_image
- group_content_image_id — BIGINT — Primary key — NOT NULL
- group_content_id — BIGINT — Foreign key → group_content.group_content_id — NOT NULL
- image_path — TEXT — NOT NULL
group_content_like
- group_content_like_id — BIGINT — Primary key — NOT NULL
- group_content_id — BIGINT — Foreign key → group_content.group_content_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
group_create_user
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- group_id — BIGINT — Foreign key → group_table.group_id — NOT NULL
group_join_member
- group_join_member_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → group_table.group_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- group_role — VARCHAR(50) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- group_join_member_status — VARCHAR(50) — NOT NULL
- deleted_at — DATETIME(6) — NOT NULL
group_like
- group_like_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- group_id — BIGINT — Foreign key → group_table.group_id — NOT NULL
group_meeting
- group_meeting_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → group_table.group_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(500) — NOT NULL
- max_participant — TINYINT — NOT NULL
- meeting_start_date — DATETIME(6) — NOT NULL
- meeting_end_date — DATETIME(6)
- location — TEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- update_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted_yn — BIT — NOT NULL
group_meeting_participant
- group_meeting_participant_id — BIGINT — Primary key — NOT NULL
- group_meeting_id — BIGINT — Foreign key → group_meeting.group_meeting_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- group_id — BIGINT — Foreign key → group_table.group_id — NOT NULL
group_table
- group_id — BIGINT — Primary key — NOT NULL
- sgg — VARCHAR(10) — Foreign key → sigg_area.sgg — NOT NULL
- sport_id — INT — Foreign key → sport.sport_id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- limit_person (limit) — TINYINT — NOT NULL
- introduce — TEXT — NOT NULL
- thumbnail_path — TEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- group_status — VARCHAR(50) — NOT NULL
- deleted_at — DATETIME(6)
member
- member_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- status — VARCHAR(100)
- profile_img — TEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- member_status — VARCHAR(50) — NOT NULL
- deleted_at — DATETIME(6)
member_active_area
- member_active_area_id — BIGINT — Primary key — NOT NULL
- sgg — VARCHAR(10) — Foreign key → sigg_area.sgg — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
member_calendar
- member_calendar_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → group_table.group_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- group_meeting_id — BIGINT — Foreign key → group_meeting.group_meeting_id — NOT NULL
- meeting_active_status — VARCHAR(50) — NOT NULL
member_content
- member_content_Id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- title — VARCHAR(30) — NOT NULL
- content — LONGTEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_yn — BIT — NOT NULL
- deleted_at — DATETIME(6)
- notice_yn — BIT
- sort_value — INT
member_content_comment
- member_content_comment_id — BIGINT — Primary key — NOT NULL
- member_content_Id — BIGINT — Foreign key → member_content.member_content_Id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_yn — BIT — NOT NULL
- deleted_at — DATETIME(6)
member_content_comment_like
- member_content_comment_like_id — BIGINT — Primary key — NOT NULL
- member_content_comment_id — BIGINT — Foreign key → member_content_comment.member_content_comment_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
member_content_image
- member_content_image_id — BIGINT — Primary key — NOT NULL
- member_content_Id — BIGINT — Foreign key → member_content.member_content_Id — NOT NULL
- img_path — TEXT — NOT NULL
member_content_like
- member_content_like_id — BIGINT — Primary key — NOT NULL
- member_content_Id — BIGINT — Foreign key → member_content.member_content_Id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
member_interested_sport
- member_interested_sport_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- sport_id — INT — Foreign key → sport.sport_id — NOT NULL
member_login_history
- member_history_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- login_dt — DATETIME(6) — NOT NULL
- cilent_ip — VARCHAR(50) — NOT NULL
- user_agent — VARCHAR(255) — NOT NULL
member_refresh_token
- member_email — VARCHAR(255) — Primary key — NOT NULL
- refresh_token — VARCHAR(500) — NOT NULL
- expire_date — DATETIME(6) — NOT NULL
member_role
- member_roll_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- member_role — VARCHAR(50) — NOT NULL
sido_area
- sido — VARCHAR(10) — Primary key — NOT NULL
- sidonm — VARCHAR(50) — NOT NULL
sigg_area
- sgg — VARCHAR(10) — Primary key — NOT NULL
- sido — VARCHAR(10) — Foreign key → sido_area.sido — NOT NULL
- sidonm — VARCHAR(50) — NOT NULL
- sggnm — VARCHAR(50) — NOT NULL
sport
- sport_id — INT — Primary key — NOT NULL
- sport_category_id — INT — Foreign key → sport_category.sport_category_id — NOT NULL
- name — VARCHAR(20) — NOT NULL
- emoji_path — TEXT — NOT NULL
sport_category
- sport_category_id — INT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL