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: 마감