sdss

Tables (14)

board_comment

  • id — BIGINT
  • board_post_id — BIGINT — Foreign key → board_post.id
  • user_id — BIGINT — Foreign key → member.id
  • content — TEXT
  • created_at — TIMESTAMP

board_post

  • id — BIGINT
  • author_user_id — BIGINT — Foreign key → member.id
  • title — VARCHAR(255)
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

board_post_bookmark

  • id — BIGINT
  • board_post_id — BIGINT — Foreign key → board_post.id
  • user_id — BIGINT — Foreign key → member.id
  • created_at — TIMESTAMP

board_post_image

  • id — BIGINT
  • post_id — BIGINT — Foreign key → board_post.id
  • image_url — VARCHAR(255)

board_post_like

  • id — BIGINT
  • board_post_id — BIGINT — Foreign key → board_post.id
  • user_id — BIGINT — Foreign key → member.id
  • created_at — TIMESTAMP

member

  • id — BIGINT
  • provider — VARCHAR(255)
  • provider_sub — VARCHAR(255)
  • email — VARCHAR(255)
  • contact_email — VARCHAR(255)
  • email_verified — BOOLEAN
  • nickname — VARCHAR(255)
  • role — VARCHAR(255)
  • intro — VARCHAR(255)
  • github_url — VARCHAR(255)
  • profile_image_url — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • team_profile_registered — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

member_activity_category

  • id — BIGINT
  • member_id — BIGINT — Foreign key → member.id
  • activity_category — VARCHAR(255)

member_bookmark

  • id — BIGINT
  • member_id — BIGINT — Foreign key → member.id
  • target_member_id — BIGINT — Foreign key → member.id
  • created_at — TIMESTAMP

member_review

  • id — BIGINT
  • writer_user_id — BIGINT — Foreign key → member.id
  • target_user_id — BIGINT — Foreign key → member.id
  • recruit_post_id — BIGINT — Foreign key → recruit_post.id
  • rating — SMALLINT
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

member_tech_stack

  • id — BIGINT
  • member_id — BIGINT — Foreign key → member.id
  • tech_stack_id — BIGINT — Foreign key

recruit_application

  • id — BIGINT
  • recruit_post_id — BIGINT — Foreign key → recruit_post.id
  • user_id — BIGINT — Foreign key → member.id
  • name — VARCHAR(255)
  • role — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • contact_email — VARCHAR(255)
  • github_url — VARCHAR(255)
  • introduction — TEXT
  • required_skills — VARCHAR(255)
  • status — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

recruit_post

  • id — BIGINT
  • author_user_id — BIGINT — Foreign key → member.id
  • activity_category — VARCHAR(255)
  • recruit_category — VARCHAR(255)
  • department — VARCHAR(255)
  • tag — VARCHAR(255)
  • title — VARCHAR(255)
  • content — TEXT
  • required_skills — VARCHAR(255)
  • status — VARCHAR(255)
  • total_headcount — SMALLINT
  • applicant_count — SMALLINT
  • deadline — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

recruit_post_bookmark

  • id — BIGINT
  • recruit_post_id — BIGINT — Foreign key → recruit_post.id
  • user_id — BIGINT — Foreign key → member.id
  • created_at — TIMESTAMP

tech_stack

  • id — BIGINT
  • name — VARCHAR(255)