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