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)