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