구름톤 해커톤
테이블 (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