ㄹㄹㄹ
Tables (3)
customer
- customerId — int — Primary key — NOT NULL
- customerAddress — varchar(50) — NOT NULL
- email — char(50)
- cusTel — char(20) — NOT NULL
- customerName — char(50) — NOT NULL
review
- reviewId — int — Primary key — NOT NULL
- customerId — int — Foreign key → customer.customerId — NOT NULL
- storeId — int — Foreign key → stores.storeId — NOT NULL
- starRating — int — NOT NULL
- content — varchar(255)
- createdDate — date
stores
- storeId — int — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- rating — decimal(2,1) — NOT NULL
- deliveryTip — int — NOT NULL
- openingHours — varchar(20)
- packagingAvailability — char(10) — NOT NULL
- tel — varchar(20) — NOT NULL
- address — varchar(30) — NOT NULL
- category — char(10) — NOT NULL