tteampllaneerr

Tables (20)

activity

  • activity_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • detail — varchar(255)
  • end_date — date
  • start_date — date
  • subject — varchar(255) — NOT NULL
  • member_id — bigint

basic_profile

  • basic_profile_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • address — varchar(255)
  • admission_date — date
  • birth — date
  • contact_email — varchar(255)
  • education — varchar(255)
  • evaluation_public — bit(1)
  • gender — varchar(255)
  • graduation_date — date
  • is_public — bigint
  • job — varchar(255)
  • kakao_id — varchar(255)
  • profile_image — varchar(255)
  • profile_intro — varchar(1000)
  • member_id — bigint

board

  • board_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • activity_detail — mediumtext
  • activity_name — varchar(255)
  • activity_area — varchar(255)
  • activity_benefits — varchar(255)
  • activity_field — varchar(255)
  • activity_img — varchar(255)
  • activity_key — varchar(255)
  • activity_period — varchar(255)
  • activity_url — text
  • category — varchar(255)
  • company_type — varchar(255)
  • competition_category — varchar(255)
  • homepage — mediumtext
  • interest_area — varchar(255)
  • meeting_time — varchar(255)
  • preferred_skills — varchar(255)
  • prize_scale — varchar(255)
  • recruitment_count — varchar(255)
  • recruitment_period — varchar(255)
  • target — varchar(255)
  • member_id — bigint
  • view — bigint — NOT NULL
  • like_count — bigint — NOT NULL

board_like

  • board_like_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • board_id — bigint
  • member_id — bigint

certification

  • certification_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • gain_date — date
  • name — varchar(255) — NOT NULL
  • score — double — NOT NULL
  • member_id — bigint

chatroom

  • chatroom_id — bigint — Primary key — NOT NULL

chatroom_member

  • chatroom_member_id — bigint — Primary key — NOT NULL
  • chatroom_id — bigint
  • member_id — bigint

comment

  • comment_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • child_comment_count — int
  • content — varchar(255) — NOT NULL
  • depth — int — NOT NULL
  • is_confidential — bit(1) — NOT NULL
  • state — bit(1) — NOT NULL
  • board_id — bigint
  • member_id — bigint
  • parent_comment_id — bigint — Foreign key → comment.comment_id

evaluation

  • evaluation_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • comment — varchar(255)
  • stat1 — int
  • stat2 — int
  • stat3 — int
  • stat4 — int
  • stat5 — int
  • author_member_id — bigint
  • subject_member_id — bigint
  • team_id — bigint

flyway_schema_history

  • installed_rank — int — Primary key — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int — NOT NULL
  • success — tinyint(1) — NOT NULL

member

  • member_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • email — varchar(255)
  • username — varchar(300)
  • member_role — varchar(255)
  • password — varchar(300)
  • provider_id — varchar(255)
  • provider_type — varchar(255)
  • state — bit(1)
  • nickname — varchar(300) — NOT NULL

member_team

  • id — bigint — Primary key — NOT NULL
  • role — varchar(255)
  • member_id — bigint
  • team_id — bigint

recruitment

  • recruitment_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255)
  • current_member_size — int
  • like_count — int
  • max_member_size — int
  • title — varchar(255)
  • view_count — int
  • member_id — bigint
  • board_id — bigint

recruitment_apply

  • recruitment_apply_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255)
  • state — varchar(255)
  • member_id — bigint
  • recruitment_id — bigint

recruitment_comment

  • recruitment_comment_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255) — NOT NULL
  • is_confidential — bit(1) — NOT NULL
  • is_deleted — bit(1) — NOT NULL
  • member_id — bigint
  • parent_comment_id — bigint — Foreign key → recruitment_comment.recruitment_comment_id
  • recruitment_id — bigint

recruitment_like

  • recruitment_like_id — bigint — Primary key — NOT NULL
  • member_id — bigint
  • recruitment_id — bigint

team

  • team_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • end_date — datetime(6)
  • start_date — datetime(6)
  • team_capacity — bigint
  • team_leader — varchar(255)
  • team_name — varchar(255)
  • team_size — bigint
  • recruitment_id — bigint

tech_stack

  • tech_stack_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • skill_level — int
  • member_id — bigint
  • tech_stack_item_id — bigint

tech_stack_item

  • tech_stack_item_id — bigint — Primary key — NOT NULL
  • image_url — varchar(255)
  • name — varchar(255)
  • tech_category — varchar(255)
  • user_generated — bit(1)

tech_stack_item_activity_mapping

  • tech_stack_item_activity_mapping_id — bigint — Primary key — NOT NULL
  • activity_id — bigint
  • tech_stack_item_id — bigint