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