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