untitled_project

Tables (9)

dj_genre (Untitled9)

  • dj_id (Key) — int — Foreign key → dj_profile.id — NOT NULL
  • genre_id (Key2) — int — Foreign key → genre.id — NOT NULL

dj_profile (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → user.id — NOT NULL
  • name (Field) — varchar(50)
  • social_link1 (Field2) — varchar(100)
  • social_link2 (Field3) — varchar(100)
  • social_link3 (Field5) — varchar(100)
  • social_link4 (Field6) — varchar(100)
  • description (Field4) — text

favorite_dj (Untitled3)

  • user_id (Key) — int — Foreign key → user.id — NOT NULL
  • dj_id (Key2) — int — Foreign key → dj_profile.id — NOT NULL

favorite_party (Untitled5)

  • user_id (Key) — int — Foreign key → user.id — NOT NULL
  • party_id (Key2) — int — Foreign key → party.id — NOT NULL

genre (Untitled6)

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

party (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key3) — int — Foreign key → user.id — NOT NULL
  • venue_id (Key2) — int — Foreign key → venue.id — NOT NULL
  • location (Field) — varchar(256)
  • poster_image_url (Field2)
  • date (Field3) — datetime
  • price (Field6) — int
  • description (Field5) — text
  • created_at (Field4) — datetime
  • updated_at (Field7) — datetime

party_dj (Untitled8)

  • party_id (Key) — int — Foreign key → party.id — NOT NULL
  • dj_id (Key2) — int — Foreign key → dj_profile.id — NOT NULL

user (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar(256)
  • password (Field2) — varchar(256)
  • name (Field7) — varchar(50)
  • profile_image_url (Field3)
  • role (Field4) — enum
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime

venue (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field3) — varchar(50)
  • location (Field) — varchar(50)
  • address (Field2) — varchar(100)