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