8_분석실습
테이블 (5)
Artist (Untitled2)
- id (pk) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
- group_name (Field2) — VARCHAR(50)
Credit_log (Untitled4)
- id (pk) — INT — 기본 키 — NOT NULL
- user_id (fk) — INT — 외래 키 → User.id — NOT NULL
- amount (Field) — INT — NOT NULL
- types (Field2) — VARCHAR(50) — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
User (Untitled)
- id (pk) — INT — 기본 키 — NOT NULL
- email (Field) — VARCHAR(50)
- password (Field2) — VARCHAR(100)
- nickname (Field3) — VARCHAR(50)
- credits (Field4) — INT
Vote (Untitled3)
- id (Key) — INT — 기본 키 — NOT NULL
- user_id (fk) — INT — 외래 키 → User.id — NOT NULL
- artist_id (fk2) — INT — 외래 키 → Artist.id — NOT NULL
- category (Field) — VARCHAR(50)
- voted_at (Field2) — DATETIME
follow (Untitled5)
- id (Key) — INT — 기본 키 — NOT NULL
- user_id (fk) — INT — 외래 키 → User.id — NOT NULL
- id (fk2) — INT — 외래 키 → Artist.id — NOT NULL