sprint_17
Tables (8)
Artist
- artist_id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- agency — VARCHAR(100)
- debut_date — DATE
- description — TEXT
- user_id — INT
Category
- category_id — INT — Primary key — NOT NULL
- name — VARCHAR(100)
- description — TEXT
- vote_id — INT — Foreign key → Vote.vote_id — NOT NULL
CreditTransaction
- transaction_id — INT — Primary key — NOT NULL
- user_id (Field) — INT
- artist_id — INT
- followed_at — DATETIME
- Field2
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
Follow
- follow_id — INT — Primary key — NOT NULL
- user_id — INT
- artist_id — INT
- followed_at (Field) — DATETIME
- Field2
- Key (user_id2) — int — Foreign key → User.Key — NOT NULL
- artist_id (artist_id2) — INT — Foreign key → Artist.artist_id — NOT NULL
Project
- project_id (project_if) — INT — Primary key — NOT NULL
- artist_id — INT
- title — VARCHAR(255)
- goal_credit — INT
- current_credit — INT
- start_date — DATE
- end_date (Field) — DATE
- status — ENUM
- artist_id (artist_id2) — INT — Foreign key → Artist.artist_id — NOT NULL
- support_id — INT — Foreign key → Support.support_id — NOT NULL
- support_id (support_id2) — INT — Foreign key → Support.support_id — NOT NULL
Support
- support_id — INT — Primary key — NOT NULL
- user_id — INT
- project_id — INT
- supported_at — DATETIME
- supported_credit — INT
- Key (user_id2) — int — Foreign key → User.Key — NOT NULL
User
- Key (user_id) — int — Primary key — NOT NULL
- password — varchar(50)
- name — varchar(50)
- Field2 (email) — varchar(100)
- credit_balance — INT
- credit_at — DATETIME
- profile_image_url — varchar(255)
Vote
- vote_id — INT — Primary key — NOT NULL
- user_id — INT
- artist_id — INT
- category_id — INT
- vote_credit — INT
- vote_at — DATETIME
- Key (user_id2) — int — Foreign key → User.Key — NOT NULL