guest house service
Tables (9)
Applicants (applicants)
- uid — BIGINT — Primary key — NOT NULL
- date_created — DATETIME
- resume_uid — BIGINT — Foreign key → Resumes.uid — NOT NULL
- recruitment_uid — BIGINT — Foreign key → Recruitments.uid — NOT NULL
Guest Houses (guest_houses)
- uid — BIGINT — Primary key — NOT NULL
- guest_house_name — VARCHAR(25)
- email — VARCHAR(255)
- phone — VARCHAR(25)
- address — VARCHAR(255)
- address_detail — VARCHAR(255)
- introduction — TEXT
- date_created — DATETIME
- representative_uid — BIGINT — Foreign key → Users.uid — NOT NULL
Recruitments (recruitments)
- uid — BIGINT — Primary key — NOT NULL
- content — TEXT
- date_created — DATETIME
- date_updated — DATETIME
- welfare — TEXT
- guest_house_uid — BIGINT — Foreign key → Guest Houses.uid — NOT NULL
Recruitments and Works (recruitments_and_works)
- recruitment_uid — BIGINT — Foreign key → Recruitments.uid — NOT NULL
- work_uid — BIGINT — Foreign key → Works.uid — NOT NULL
Resumes (resumes)
- uid — BIGINT — Primary key — NOT NULL
- content — TEXT
- possible_start_date — DATETIME
- possible_end_date — DATETIME
- work_start_time_desired — TIME()
- work_end_time_desired — TIME()
- auto_apply — BOOLEAN
- date_created — DATETIME
- user_uid — BIGINT — Foreign key → Users.uid — NOT NULL
Staff histories (staff_histories)
- uid — BIGINT — Primary key — NOT NULL
- start_date — DATETIME
- end_date — DATETIME
- on_duty — BOOLEAN
- guest_house_uid — BIGINT — Foreign key → Guest Houses.uid — NOT NULL
- user_uid — BIGINT — Foreign key → Users.uid — NOT NULL
Users (users)
- uid — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(255)
- password — VARCHAR(255)
- username — VARCHAR(25)
- email — VARCHAR(255)
- email_receive_allow — BOOLEAN
- phone — VARCHAR(25)
- phone_receive_allow — BOOLEAN
- address — VARCHAR(255)
- address_detail — VARCHAR(255)
- date_created — DATETIME
- gender — ENUM('M','F','X')
- age — INT
- facebook_link — VARCHAR(100)
- facebook_link (Field) — VARCHAR(100)
- profile_img_url — VARCHAR(255)
- introduction — TEXT
Work Details (work_details)
- uid — BIGINT — Primary key — NOT NULL
- work_uid — BIGINT — Foreign key → Works.uid — NOT NULL
- work_day — VARCHAR(25)
- work_start_time — TIME()
- work_end_time — TIME()
- personnel — INT
Works (works)
- uid — BIGINT — Primary key — NOT NULL
- work_name — VARCHAR(25)
- personnel — INT
- work_description — TEXT