Gdgoc
Tables (8)
Application
- application_id — BIGINT — Primary key
- vacancy_id (vacancy_id2) — BIGINT — Foreign key → VacancySchedule.vacancy_id
- store_profile_id (store_profile_id2) — BIGINT — Foreign key → VacancySchedule.store_profile_id
- member_id (member_id2) — BIGINT — Foreign key → VacancySchedule.member_id
- category_id (category_id2) — INT — Foreign key → VacancySchedule.category_id
- user_profile_id — BIGINT — NOT NULL — 지원자
- vacancy_id — BIGINT — NOT NULL — 지원 공고
- status — ENUM('PENDING', 'CONFIRMED', 'REJECTED', 'CANCELED') — NOT NULL
- message — TEXT — 지원 메시지
- created_at — DATETIME
AvailabilitySchedule
- availability_id — BIGINT — Primary key
- user_profile_id (user_profile_id2) — BIGINT — Foreign key → UserProfile.user_profile_id
- member_id (member_id2) — BIGINT — Foreign key → UserProfile.member_id
- user_profile_id — BIGINT — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
Category
- category_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL — e.g., 카페, 편의점
Member
- member_id — BIGINT — Primary key
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — ENUM('USER', 'STORE') — NOT NULL — USER: 구직자, STORE: 매장
- created_at — DATETIME
- updated_at — DATETIME
Notification
- notification_id — BIGINT — Primary key
- member_id (member_id2) — BIGINT — Foreign key → Member.member_id
- member_id — BIGINT — NOT NULL — 알림 수신자
- message — VARCHAR(255) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- link_url — VARCHAR(2048) — 클릭 시 이동할 경로
- created_at — DATETIME
StoreProfile
- store_profile_id — BIGINT — Primary key
- member_id (member_id2) — BIGINT — Foreign key → Member.member_id
- category_id (category_id2) — INT — Foreign key → Category.category_id
- member_id — BIGINT — NOT NULL — Member와 1:1 관계
- category_id — INT
- store_name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- business_number — VARCHAR(100)
- store_image_url — VARCHAR(2048)
UserProfile
- user_profile_id — BIGINT — Primary key
- member_id (member_id2) — BIGINT — Foreign key → Member.member_id
- member_id — BIGINT — NOT NULL — Member와 1:1 관계
- introduction — TEXT
- experience — TEXT
- desired_region — VARCHAR(255)
- profile_image_url — VARCHAR(2048)
VacancySchedule
- vacancy_id — BIGINT — Primary key
- store_profile_id (store_profile_id2) — BIGINT — Foreign key → StoreProfile.store_profile_id
- member_id (member_id2) — BIGINT — Foreign key → StoreProfile.member_id
- category_id (category_id2) — INT — Foreign key → StoreProfile.category_id
- store_profile_id — BIGINT — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- positions_needed — INT — NOT NULL — 필요 인원
- positions_filled — INT — NOT NULL — 채용된 인원
- status — ENUM('OPEN', 'CLOSED') — NOT NULL — OPEN: 모집중, CLOSED: 마감