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