studify
Tables (9)
Untitled (user)
- Key (id) — int — Primary key — NOT NULL
- Key (user_img_id) — int — Foreign key → Untitled.Key
- Field (email) — varchar(255) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field2 (name) — varchar(255) — NOT NULL
- Field (generation) — int — NOT NULL
- Field2 (region) — varchar(255) — NOT NULL
- Field (class_num) — int — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
- Field (total_time) — time — NOT NULL
Untitled (user_conference_log)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (conference_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (user_img)
- Key (id) — int — Primary key — NOT NULL
- Field (file_url) — varchar(255)
- Field2 (name) — varchar(255)
- Field (type) — varchar(255)
Untitled (study)
- Key (id) — int — Primary key — NOT NULL
- Field (thumbnail_url) — varchar(255)
- Field (title) — varchar(255) — NOT NULL
- Field (description) — varchar(255)
- Field (capacity) — int — NOT NULL
- Field (day) — varchar(255) — NOT NULL
- Field (skill) — varchar(255)
- Field (is_public) — boolean — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
Untitled (user_study)
- Key (id) — int — Primary key — NOT NULL
- Key (study_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (badge)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
Untitled (user_badge)
- Key (id) — int — Primary key — NOT NULL
- Key (badge_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (date)
Untitled (conference_log)
- Key (id) — int — Primary key — NOT NULL
- Key (study_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (user_time_log)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (day) — date — NOT NULL
- Field (study_time) — int — NOT NULL