bandwagon
Tables (24)
Copy Of Copy Of Untitled2 (prerequisite_positions)
- Key (prerequisite_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Key (position_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Copy Of Untitled (band_practices)
- Key (id) — int8 — Primary key — NOT NULL
- Key (band_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Field (music_title) — varchar(255)
- Field (perform_date) — date
- Field (urls) — jsonb
Copy Of Untitled2 (prerequisite_genres)
- Key (prerequisite_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Key (genre_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Untitled (band_photos)
- Key (id) — int8 — Primary key — NOT NULL
- Key (band_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Field (img_url) — text
Untitled (user_infos)
- Key (user_info_id) — int8 — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.user_id — NOT NULL
- Field (avatar_url) — text
- Field (description) — text
Untitled (prerequisite_areas)
- Key (band_prerequisite_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Key (area_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Untitled (band_prerequisites)
- Key (band_prerequisite_id) — int8 — Primary key — NOT NULL
- Key (post_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Field (dtype) — varchar(31)
- Field (max) — int4
- Field (min) — int4
- Field (gender) — bool
Untitled (band_member_positions)
- Key (band_member_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Key (position_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Untitled (posts)
- Key (post_id) — int8 — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.user_id — NOT NULL
- Key (band_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Field (dtype) — varchar(31)
- Field (body) — text
- Field (created_at) — timestamp
- Field (title) — varchar(255)
- Field (updated_at) — timestamp
- Field (view) — int4
Untitled (band_days)
- Key (band_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Key (day_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Untitled (days)
- Key (id) — int8 — Primary key — NOT NULL
- Field (day) — varchar(255)
Untitled (band_areas)
- Key (band_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Key (area_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Untitled (band_genres)
- Key (band_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Key (genre_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Untitled (user_performances)
- Key (id) — int8 — Primary key — NOT NULL
- user_id — int8 — Foreign key → users.user_id — NOT NULL
- Field (music_title) — varchar(255)
- Field (perform_date) — date
- Field (urls) — jsonb
Untitled (band_gigs)
- Key (id) — int8 — Primary key — NOT NULL
- Key (band_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Field (music_title) — varchar(255)
- Field (perform_date) — date
- Field (urls) — jsonb
Untitled (bands)
- Key (band_id) — int8 — Primary key — NOT NULL
- Field (avatar_url) — text
- Field (description) — text
- Field (name) — varchar(255)
Untitled (band_members)
- Key (id) — int8 — Primary key — NOT NULL
- user_id (member_id) — int8 — Foreign key → users.user_id — NOT NULL
- Key (band_id) — int8 — Foreign key → Untitled.Key — NOT NULL
- Field (is_frontman) — bool
Untitled (user_areas)
- user_id — int8 — Foreign key → users.user_id — NOT NULL
- Key (area_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Untitled (areas)
- Key (id) — int8 — Primary key — NOT NULL
- Field (city) — varchar(255)
- Field (district) — varchar(255)
Untitled (user_genres)
- user_id — int8 — Foreign key → users.user_id — NOT NULL
- Key (genre_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Untitled (genres)
- Key (id) — int8 — Primary key — NOT NULL
- Field (genre) — varchar(255)
Untitled (user_positions)
- user_id — int8 — Foreign key → users.user_id — NOT NULL
- Key (position_id) — int8 — Foreign key → Untitled.Key — NOT NULL
Untitled (positions)
- Key (id) — int8 — Primary key — NOT NULL
- Field (position) — varchar(255)
users
- user_id — int8 — Primary key — NOT NULL
- Field (birthday) — date
- Field (email) — varchar(255)
- Field (gender) — bool
- Field (is_social) — bool
- Field (name) — varchar(255)
- Field (nickname) — varchar(255)
- Field (password) — varchar(255)