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)