sky-kongkong

Tables (4)

report

  • report_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • is_ solved — tinyint
  • category — varchar(10)
  • detail (datail) — varchar(300)
  • updated_at — datetime
  • created_at — datetime

usage

  • usage_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • seat_id — int
  • check_in — datetime
  • use_minutes — int
  • check_out — datetime
  • is_active — boolean

user

  • user_id — int — Primary key — NOT NULL
  • phone — varchar(11)
  • name
  • password — varchar(20)
  • created_at — datetime
  • updated_at — datetime

user_time

  • user_time_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • remain_minutes — int
  • created_at — datetime
  • updated_at — datetime