ola
Tables (10)
board_job_roles
- board_id — bigint — NOT NULL
- board_job_role_id — bigint
- job_role_id — bigint — NOT NULL
board_tech_statcks
- board_id — bigint — NOT NULL
- board_tech_stack_id — bigint
- tech_stack_id — bigint — NOT NULL
boards
- interest_count — int
- recruitment_count — int
- view_count — int
- author_id — bigint — NOT NULL
- board_id — bigint
- created_at — datetime(6)
- duration — datetime(6)
- recruitment_deadline — datetime(6)
- updated_at — datetime(6)
- contact_method — varchar(255)
- content — text — NOT NULL
- title — varchar(255) — NOT NULL
- progress_method — enum
- recruitment_type — enum — NOT NULL
- status — enum
comments
- author_id — bigint — NOT NULL
- board_id — bigint — NOT NULL
- comment_id — bigint
- created_at — datetime(6)
- parent_id — bigint
- updated_at — datetime(6)
- content — text — NOT NULL
job_roles
- job_role_id — bigint
- name — varchar(255)
links
- link_id — bigint
- url — varchar(255)
member_links
- link_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- member_link_id — bigint
member_tech_stacks
- member_id — bigint — NOT NULL
- member_tech_stack_id — bigint
- tech_stack_id — bigint — NOT NULL
members
- experience — int
- created_at — datetime(6)
- job_role_id — bigint — NOT NULL
- member_id — bigint
- updated_at — datetime(6)
- introduction — varchar(1000)
- affiliation — varchar(255)
- email — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- profile_url — varchar(255)
tech_stacks
- tech_stack_id — bigint
- image_url — varchar(255)
- name — varchar(255)