mission8

Tables (8)

Artists (아티스트)

  • Key — INT — Primary key — NOT NULL
  • Field — VARCHAR(100)
  • Field2 — VARCHAR(100)
  • Field3 — DATE

Credit_Transactions (크레딧 거래이력)

  • Key — INT — Primary key — NOT NULL
  • Field — INT
  • Field2 — INT
  • Field3 — VARCHAR(20)
  • Field4 — DATETIME
  • Key (Key2) — INT — Foreign key → Users.Key — NOT NULL

Donations (후원내역)

  • Key — INT — Primary key — NOT NULL
  • Field — INT
  • Field2 — INT
  • Field4 — INT
  • Field5 — DATETIME
  • Key (Key2) — INT — Foreign key → Users.Key — NOT NULL
  • Key (Key3) — INT — Foreign key → Projects.Key — NOT NULL
  • Key (Key4) — INT — Foreign key → Credit_Transactions.Key — NOT NULL

Projects (조공 프로젝트)

  • Key — INT — Primary key — NOT NULL
  • Field — INT
  • Field2 — VARCHAR(100)
  • Field3 — INT
  • Field4 — INT
  • Field5 — VARCHAR(20)
  • Key (Key2) — INT — Foreign key → Artists.Key — NOT NULL

User_Follows_Artists (사용자-아티스트 팔로우)

  • Key — INT — Primary key — NOT NULL
  • Field — INT
  • Field2 — INT
  • Field3 — DATETIME
  • Key (Key2) — INT — Foreign key → Users.Key — NOT NULL
  • Key (Key3) — INT — Foreign key → Artists.Key — NOT NULL

Users (사용자)

  • Key — INT — Primary key — NOT NULL
  • Field — VARCHAR(50)
  • Field2 — VARCHAR(100)
  • Field3 — INT
  • Field4 — DATETIME

Vote_Events (투표 이벤트 정보)

  • Key — INT — Primary key — NOT NULL
  • Field — VARCHAR(100)
  • Field2 — DATE
  • Field3 — DATE

Votes (투표 이력)

  • Key — INT — Primary key — NOT NULL
  • Field — INT
  • Field2 — INT
  • Field3 — INT
  • Field5 — INT
  • Field6 — DATETIME
  • Key (Key2) — INT — Foreign key → Users.Key — NOT NULL
  • Key (Key3) — INT — Foreign key → Artists.Key — NOT NULL
  • Key (Key4) — INT — Foreign key → Vote_Events.Key — NOT NULL
  • Key (Key5) — INT — Foreign key → Credit_Transactions.Key — NOT NULL