codeit
Tables (5)
artists (Untitled3)
- artist_id (Key) — NOT NULL — Primary key — NOT NULL
- name (Field) — NOT NULL
- group (Field2)
- agency (Field3)
- profile_image_url (Field4) — NOT NULL
credit_transactions (Untitled5)
- transaction_id (Key) — NOT NULL — Primary key — NOT NULL
- user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
- support_id (Key3) — NOT NULL — Foreign key → supports.support_id — NOT NULL
- amount (Field) — NOT NULL
- Field3
- label (Field2)
- Field4
supports (Untitled2)
- support_id (Key) — NOT NULL — Primary key — NOT NULL
- title (Field) — NOT NULL
- Field2
user (Untitled)
- user_id (Key) — NOT NULL — Primary key — NOT NULL
- id (Field) — NOT NULL
- password (Field2) — NOT NULL
- nickname (Field3) — NOT NULL
- credit (Field4)
votes (Untitled4)
- artist_id (Key2) — NOT NULL — Foreign key → artists.artist_id — NOT NULL
- user_id (Key) — NOT NULL — Foreign key → user.user_id — NOT NULL
- vote_count (Field)
- Field2