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