sca
Tables (3)
Date Lunch (lunch)
- Primary Key (id) — int — Primary key — NOT NULL
- Date (date) — date — NOT NULL
- Lunch Image (img) — Text
- Lunch Menu (menu) — Text — NOT NULL
Rating and Comment (rating)
- Primary Key (id) — int — Primary key — NOT NULL
- User Forigen Key (user_id_fk) — int — Foreign key → User Table.Primary Key — NOT NULL
- Lunch Forigen Key (lunch_id_fk) — int — Foreign key → Date Lunch.Primary Key — NOT NULL
- Star Rating (star_rating) — int
- Comment (comment) — Text
User Table (user)
- Primary Key (id) — int — Primary key — NOT NULL
- Student ID (student_id) — varchar(6) — NOT NULL
- Password (password) — varchar(18) — NOT NULL
- Ninkname (ninkname) — varchar(30)