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