스플린트8

테이블 (7)

ARTISTS

  • artist_id (Field) — INT — 기본 키 — NOT NULL
  • name (Field4) — VARCHAR(100)
  • GROUP (Field5) — STRING

USERS

  • user_id (Field) — INT — 기본 키 — NOT NULL
  • email (Field2) — VARCHAR(255) — NOT NULL
  • password (Field3) — VARCHAR(255) — NOT NULL
  • name (Field4) — VARCHAR(100)
  • created_time (Field5) — DATETIME
  • credit (Field6) — DECIMAL

credit_transactions

  • credit_id (Field2) — INT — 기본 키 — NOT NULL
  • user_id (Field) — INT — 외래 키 → USERS.user_id — NOT NULL — 1
  • credit_where (Field3) — STRING — NOT NULL
  • amount (Field4) — DECIMAL
  • created_time (Field5) — DATETIME

donations

  • donations_id (Field) — INT — 기본 키 — NOT NULL
  • project_id (Field2) — INT — NOT NULL
  • user_id (Field3) — INT — NOT NULL
  • amount (Field4) — DECIMAL
  • created_time (Field5) — DATETIME

follow

  • user_id (Field3) — INT — 외래 키 → USERS.user_id — NOT NULL
  • artist_id (Field4) — INT
  • created_time (Field2) — DATETIME

projcts

  • projcts_id (Field) — INT — 기본 키 — NOT NULL
  • artist_id (Field2) — INT — NOT NULL
  • title (Field3) — VARCHAR(100) — NOT NULL
  • target_amount (Field4) — DECIMAL
  • deadline (Field5) — DATETIME
  • created_time (Field6) — DATETIME

votes

  • vote_id (Field) — INT — 기본 키 — NOT NULL
  • user_id (Field2) — INT — NOT NULL
  • artist_id (Field3) — INT — NOT NULL
  • votes_count (Field4) — INT
  • created_time (Field5) — DATETIME