TOGEDUCK

Tables (14)

Untitled (user)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Field (user_id) — varchar(20) — NOT NULL
  • Field (password) — varchar(100) — NOT NULL
  • Field (nickname) — varhcar(20) — NOT NULL
  • Field (email) — varchar(50) — NOT NULL
  • Field (authorization) — enum — NOT NULL

Untitled (festival)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Key (category_id) — BigInt — Foreign key → Untitled.Key — NOT NULL
  • Key (citiy_id) — BigInt — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field (content) — varchar(1000)
  • Field (location) — varchar(200) — NOT NULL
  • Field (x_pos) — double — NOT NULL
  • Field (y_pos) — double — NOT NULL
  • Field (started_at) — datetime — NOT NULL
  • Field (ended_at) — datetime — NOT NULL
  • Field (status) — Enum — NOT NULL
  • Field (thumbnail_path) — varchar(200) — NOT NULL

Untitled (festival_image)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Key (festival_id) — BigInt — Foreign key → Untitled.Key — NOT NULL
  • Field (path) — varchar(200) — NOT NULL

Untitled (route)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Key (festival_id) — BigInt — Foreign key → Untitled.Key — NOT NULL
  • Key (station_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (bus_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (driver_id) — BigInt — Foreign key → Untitled.Key
  • Field (status) — enum — NOT NULL
  • Field (started_at) — datetime — NOT NULL
  • Field (expected_time) — time — NOT NULL
  • Field (price) — int — NOT NULL
  • Field (distance) — int — NOT NULL
  • Field (car_number) — varchar(10)
  • Field (number_of_seats) — int
  • Field (number_of_reservation_seats) — int
  • Field (popular_score) — double

Untitled (seat)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Key (user_id) — BigInt — Foreign key → Untitled.Key
  • Key (route_id) — BigInt — Foreign key → Untitled.Key — NOT NULL
  • Field (no) — int — NOT NULL
  • Field (status) — enum — NOT NULL

Untitled (city)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(10) — NOT NULL

Untitled (station)

  • Key (id) — int — Primary key — NOT NULL
  • Key (city_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(200) — NOT NULL
  • Field (x_pos) — double — NOT NULL
  • Field (y_pos) — double — NOT NULL

Untitled (bus)

  • Key (id) — int — Primary key — NOT NULL
  • Field (type) — enum — NOT NULL
  • Field (number_of_seats) — int — NOT NULL
  • Field (row) — int — NOT NULL
  • Field2 (column) — int — NOT NULL
  • Field (back_seat) — int — NOT NULL

Untitled (price_table)

  • Key (id) — int — Primary key — NOT NULL
  • Key (bus_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (distance) — int — NOT NULL
  • Field (price) — int — NOT NULL

Untitled (driver)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Field (name) — varchar(10) — NOT NULL
  • Field (company) — varchar(50) — NOT NULL
  • Field (phone_number) — varchar(11) — NOT NULL
  • Field (path) — varchar(200) — NOT NULL

Untitled (festival_view)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Key (festival_id) — BigInt — Foreign key → Untitled.Key — NOT NULL
  • Field (measurement_at) — Date — NOT NULL
  • Field (count) — BigInt — NOT NULL

Untitled (category)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Field (name) — varchar(10) — NOT NULL
  • Field (image) — varcher(100) — NOT NULL

Untitled (user_chat_room)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Key (user_id) — BigInt — Foreign key → Untitled.Key — NOT NULL
  • Key (chat_room_id) — BigInt — Foreign key → Untitled.Key — NOT NULL

Untitled (chat_room)

  • Key (id) — BigInt — Primary key — NOT NULL
  • Key (route_id) — BigInt — Foreign key → Untitled.Key — NOT NULL
  • Field (room_name) — varchar(50) — NOT NULL
  • Field (number_of_members) — int — NOT NULL
  • Field (thumbnail_path) — varchar(50) — NOT NULL