Capstone

Tables (3)

Global Reservation DB (Untitled)

  • PRIMARY_KEY (global_reservation_id) — INT — Primary key — NOT NULL
  • (reservation_date) — DATE
  • (status) — VARCHAR(20)
  • PRIMARY_KEY (user_id) — VARCHAR(20) — Foreign key → Global User DB.PRIMARY_KEY — NOT NULL

Global User DB (Untitled3)

  • PRIMARY_KEY (user_id) — VARCHAR(20) — Primary key — NOT NULL
  • (user_name) — VARCHAR(255)
  • Field (phone_number) — VARCHAR(20)
  • Field (email) — VARCHAR(255)

Reservation_Metadata (Untitled2)

  • Key — Primary key — NOT NULL
  • FOREIGN_KEY (global_reservation_id) — INT — Foreign key → Global Reservation DB.PRIMARY_KEY — NOT NULL
  • (created_at) — TIMESTAMP
  • Field (updated_at) — TIMESTAMP
  • Field (created_by) — VARCHAR(255)
  • Field (updated_by) — VARCHAR(255)
  • Field (change_log) — TEXT