ed
Tables (6)
account
- uuid — binary(16) — NOT NULL
- email — varchar(100) — NOT NULL
- name — varchar(100)
- salt — varchar(100) — NOT NULL
- is_registered — tinyint(1) — NOT NULL
- temp_token_expire_time — datetime — NOT NULL
- last_login — datetime
- register_date — int
evaluation
- id — int
- lecture — varchar(64) — NOT NULL
- submitter — binary(16) — NOT NULL
- record — int — NOT NULL
- satisfaction — int — NOT NULL
- lecture_power — int — NOT NULL
- amount_of_work — int — NOT NULL
- difficulty — int — NOT NULL
- comment — text — ext nul
lecture
- uuid — varchar(64) — NOT NULL
- lecture_code — varchar(64) — NOT NULL
- year — int(5) — NOT NULL
- semester — int(2) — NOT NULL
- class — int
- title — varchar(128) — NOT NULL
- professor — varchar(256) — NOT NULL
lecture_schedule
- id — int
- lecture — varchar(64) — NOT NULL
- day — int(5) — NOT NULL
- start_time — time — NOT NULL
- end_time — time — NOT NULL
time_table_for_account
- id — int
- account — binary(16) — NOT NULL
- lecture — varchar(64) — NOT NULL
token
- token — binary(128) — NOT NULL
- uuid — binary(16) — NOT NULL
- created_at — datetime — NOT NULL
- expires_at — datetime — NOT NULL
- user_agent — varchar(255) — NOT NULL
- created_ip — binary(16) — NOT NULL
- last_seen_ip — binary(16) — NOT NULL