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