GDGOC

Tables (7)

Application

  • application_id — BIGINT
  • seeker_id — BIGINT — NOT NULL
  • shift_id — BIGINT — NOT NULL
  • status — ENUM('PENDING', 'ACCEPTED', 'REJECTED') — NOT NULL
  • applied_at — TIMESTAMP

Member

  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • user_type — ENUM('SEEKER', 'STORE') — NOT NULL
  • social_provider — VARCHAR(50)
  • social_id — VARCHAR(255)
  • created_at — TIMESTAMP

Review

  • review_id — BIGINT
  • shift_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • seeker_id — BIGINT — NOT NULL
  • rating — INT — NOT NULL
  • comment — TEXT — EX
  • created_at — TIMESTAMP

SeekerAvailability

  • availability_id — BIGINT
  • seeker_id — BIGINT — NOT NULL
  • available_date — DATE — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL

SeekerProfile

  • user_id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • desired_job_type — VARCHAR(100)
  • desired_region — VARCHAR(100)
  • experience — TEXT
  • introduction — TEXT
  • avg_rating — DECIMAL(2, 1)

Shift

  • shift_id — BIGINT
  • store_id — BIGINT — NOT NULL
  • shift_date — DATE — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • required_job_type — VARCHAR(100)
  • status — ENUM('OPEN', 'FILLED') — NOT NULL

StoreProfile

  • user_id — BIGINT
  • store_name — VARCHAR(100) — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • business_category — VARCHAR(100)
  • introduction — TEXT