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)