Booking System

Tables (6)

Booking (booking)

  • Booking Id (id) — BIGINT — Primary key — NOT NULL
  • Booking Date and Time (created_at) — DATETIME
  • Scheduled Date and Time (scheduled_at) — DATETIME
  • Updated Date and Time (updared_at) — DATETIME
  • Booking Satus (booking_status) — VARCHAR(10)
  • Additional Info (memo) — VARCHAR(255)
  • Customer Id (member_id) — BIGINT — Foreign key → Registered Member.Member Id — NOT NULL
  • Service Id (service_id) — BIGINT — Foreign key → Service.Service Id — NOT NULL
  • Business id (business_id) — BIGINT — Foreign key → Business.Business id — NOT NULL

Bookmark (bookmark)

  • Bookmark Id (id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)
  • Member Id (member_id) — BIGINT — Foreign key → Registered Member.Member Id — NOT NULL
  • Business id (business_id) — BIGINT — Foreign key → Business.Business id — NOT NULL

Business (business)

  • Business id (id) — BIGINT — Primary key — NOT NULL
  • Business Name (business_name) — VARCHAR(100)
  • Business Description (description) — VARCHAR(255)
  • Province (province) — VARCHAR(2)
  • City (city) — VARCHAR(50)
  • Postal Code (postal_code) — VARCHAR(6)
  • Business Address (street_address) — VARCHAR(255)
  • Open Time (open_time) — TIME
  • Close Time (close_time) — TIME
  • Open Status (is_cureently_open) — BOOLEAN
  • Active Status (is_active) — BOOLEAN
  • Create Information (created_at) — DATETIME
  • Update Information (updated_at) — DATETIME
  • Member Id (member_id) — BIGINT — Foreign key → Registered Member.Member Id — NOT NULL

Registered Member (member)

  • Member Id (id) — BIGINT — Primary key — NOT NULL
  • Member Email (email) — VARCHAR(255)
  • MemberPassword (password) — VARCHAR(20)
  • Member Role (role) — VARCHAR(50)
  • Member DOB (date_of_birth) — DATIMETIME
  • Member Sex (sex) — VARCHAR(50)
  • Member First Name (first_name) — VARCHAR(50)
  • Member Last Name (last_name) — VARCHAR(50)
  • Member Display Nmae (display_name) — VARCHAR(10)
  • Member Phone Number (phone) — VARCHAR(20)

Review (review)

  • Review Id (id) — BIGINT — Primary key — NOT NULL
  • Review Title (title) — VARCHAR(50)
  • Review Content (content) — VARCHAR(255)
  • Review Rating (rate) — DOUBLE
  • Create Information (created_at) — DATETIME
  • Update Information (updated_at) — DATETIME
  • Booking Id (booking_id) — BIGINT — Foreign key → Booking.Booking Id — NOT NULL
  • Member Id (member_id) — BIGINT — Foreign key → Registered Member.Member Id — NOT NULL

Service (service_item)

  • Service Id (id) — BIGINT — Primary key — NOT NULL
  • Service Name (name) — VARCHAR(30)
  • Service Description (description) — VARCHAR(255)
  • Service Price (price) — BIGDECIMAL
  • Service Duration (duration) — VARCHAR(100)
  • Business Id (business_id) — BIGINT — Foreign key → Business.Business id — NOT NULL