ERD

Tables (12)

departments

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL

free_comment_likes

  • comment_id — BIGINT — Foreign key → free_comments.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

free_comments

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → free_posts.id — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → free_comments.id
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

free_post_likes

  • post_id — BIGINT — Foreign key → free_posts.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

free_posts

  • id — BIGINT — Primary key — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • department_id — BIGINT — Foreign key → departments.id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

parts

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL

recruit_post_tech_stacks

  • recruit_post_id — BIGINT — Foreign key → recruit_posts.id — NOT NULL
  • tech_stack_id — BIGINT — Foreign key → tech_stacks.id — NOT NULL

recruit_posts

  • id — BIGINT — Primary key — NOT NULL
  • type — ENUM('PROJECT','CONTEST','STUDY') — NOT NULL
  • author_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('OPEN','CLOSED') — NOT NULL
  • contact_type — ENUM('KAKAO','EMAIL','LINK','ETC') — NOT NULL
  • contact_value — VARCHAR(500) — NOT NULL
  • study_period — VARCHAR(100)
  • headcount_total — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

recruit_roles

  • id — BIGINT — Primary key — NOT NULL
  • recruit_post_id — BIGINT — Foreign key → recruit_posts.id — NOT NULL
  • part_id — BIGINT — Foreign key → parts.id — NOT NULL
  • headcount — INT — NOT NULL

tech_stacks

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(80) — NOT NULL

user_tech_stacks

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • tech_stack_id — BIGINT — Foreign key → tech_stacks.id — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • email_domain — VARCHAR(120) — NOT NULL
  • email_verified — TINYINT(1) — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(120) — NOT NULL
  • name — VARCHAR(80)
  • nickname — VARCHAR(80)
  • department_id — BIGINT — Foreign key → departments.id
  • grade — INT
  • part_id — BIGINT — Foreign key → parts.id
  • intro_summary — VARCHAR(200)
  • intro_detail — TEXT
  • profile_image_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL