database-project
Tables (7)
Customer
- customer_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- marketing_agree — TINYINT(1)
- birth_date — DATE
- is_deleted — TINYINT(1)
- deleted_at — DATETIME
Owner
- owner_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- business_number — VARCHAR(20) — NOT NULL
- verified_at — DATETIME
- is_deleted — TINYINT(1)
- deleted_at — DATETIME
Restaurant
- restaurant_id — INT — Primary key — NOT NULL
- owner_id — INT — Foreign key → Owner.owner_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)
- category — VARCHAR(50)
- operating_hours — VARCHAR(100)
- waiting_available — TINYINT(1)
- created_at — DATETIME
- is_deleted — TINYINT(1)
- deleted_at — DATETIME
Review
- review_id — INT — Primary key — NOT NULL
- waiting_id — INT — Foreign key → Waiting.waiting_id — NOT NULL
- rating — TINYINT — NOT NULL
- content — TEXT
- created_at — DATETIME
- is_deleted — TINYINT(1)
- deleted_at — DATETIME
ReviewReport
- report_id — INT — Primary key — NOT NULL
- review_id (review_id2) — INT — Foreign key → Review.review_id — NOT NULL
- owner_id — INT — Foreign key → Owner.owner_id — NOT NULL
- reason — VARCHAR(255) — NOT NULL
- status — VARCHAR(10)
- created_at — DATETIME
User
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_type — VARCHAR(10) — NOT NULL
- created_at — DATETIME
- is_deleted — TINYINT(1)
- deleted_at — DATETIME
Waiting
- waiting_id — INT — Primary key — NOT NULL
- restaurant_id — INT — Foreign key → Restaurant.restaurant_id — NOT NULL
- customer_id — INT — Foreign key → Customer.customer_id — NOT NULL
- party_size — INT — NOT NULL
- queue_number — INT — NOT NULL
- status — VARCHAR(10)
- created_at — DATETIME
- entered_at — DATETIME