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)