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