KU Life
Tables (8)
Board
- boardid — int — Primary key — NOT NULL
- userid — int — Foreign key → User.userid — NOT NULL
- title — String
- content — TEXT
- createtime — Date
- isactive — boolean
BusFromSchool
- id — int — Primary key — NOT NULL
- departure — Time — NOT NULL
BusFromStation
- id — int — Primary key — NOT NULL
- departure — Time — NOT NULL
Comment
- commentid — int — Primary key — NOT NULL
- boardid — int — Foreign key → Board.boardid — NOT NULL
- userid — int — Foreign key → User.userid — NOT NULL
- comment — String
- createtime — Date
- isactive — boolean
DietComment
- commentid — int — Primary key — NOT NULL
- comment — String
- createtime — Date
- isactive — booelan
Meal
- mealid — int — Primary key — NOT NULL
- restaurantid — int — Foreign key → Restaurant.restaurantid — NOT NULL
- day — String
- mealtype — String
- menu — String
- createtime — Date
Restaurant
- restaurantid — int — Primary key — NOT NULL
- name (mon) — String
User
- userid — int — Primary key — NOT NULL
- username — String
- password — String
- realname — String
- studentid — String
- major — String — 프론트에서 학과 선택하게끔 만들예정
- age — int
- createtime — Date
- role — String