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)