구름톤 해커톤

테이블 (6)

accommodation

  • accommodation_id — BIGINT
  • job_id — BIGINT — NOT NULL
  • name — VARCHAR(255)
  • type — VARCHAR(100)
  • description — TEXT

application

  • application_id — BIGINT
  • job_id — BIGINT — NOT NULL
  • worker_id — BIGINT — NOT NULL
  • contact_info — VARCHAR(20) — NOT NULL
  • status — ENUM('PENDING', 'APPROVED', 'REJECTED', 'CANCELED') — NOT NULL
  • applied_at — TIMESTAMP

chat_room

  • room_id — BIGINT
  • job_id — BIGINT — NOT NULL
  • worker_id — BIGINT — NOT NULL
  • employer_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

job_posting

  • job_id — BIGINT
  • employer_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • daily_work_time — VARCHAR(100) — NOT NULL
  • wage — INT — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • recruitment_personnel — INT — NOT NULL
  • is_accommodation_provided — BOOLEAN — NOT NULL
  • status — ENUM('RECRUITING', 'COMPLETED', 'CANCELED') — NOT NULL
  • created_at — TIMESTAMP

message

  • message_id — BIGINT
  • room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • sent_at — TIMESTAMP

user

  • user_id — BIGINT
  • username — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • role — ENUM('WORKER', 'EMPLOYER') — NOT NULL
  • created_at — TIMESTAMP