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