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