Fandom-K

Tables (8)

Artists (Untitled2)

  • Artists_ID (아티스트_ID (기본키)) — int — Primary key — NOT NULL
  • Categories_ID (카테고리_ID (Categories 테이블의 외래키)) — int — Foreign key → Categories.Categories_ID — NOT NULL
  • name (이름) — varchar(10)
  • description (설명) — varchar(50)

Categories (Untitled3)

  • Categories_ID (카테고리_ID (기본키)) — int — Primary key — NOT NULL
  • name (이름) — varchar(10)

CreditTransactions (Untitled8)

  • CreditTransactions_ID (거래_ID (기본키)) — int — Primary key — NOT NULL
  • User_ID (사용자_ID (Users 테이블의 외래키)) — int — Foreign key → User.User_ID — NOT NULL
  • amount (금액) — int
  • transaction_type (거래 유형 (충전, 후원, 투표 등)) — int
  • transaction_date (거래일) — data

Credits (Untitled6)

  • Credits_ID (크레딧_ID (기본키)) — int — Primary key — NOT NULL
  • User_ID (사용자_ID (Users 테이블의 외래키)) — int — Foreign key → User.User_ID — NOT NULL
  • balance (잔액) — int

Donations (Untitled4)

  • Donations_ID (후원_ID (기본키)) — int — Primary key — NOT NULL
  • User_ID (사용자_ID (Users 테이블의 외래키)) — int — Foreign key → User.User_ID — NOT NULL
  • Artists_ID (아티스트_ID (Artists 테이블의 외래키)) — int — Foreign key → Artists.Artists_ID — NOT NULL
  • amount (금액) — int
  • date (후원일) — date

Follows (Untitled7)

  • Follows_ID (팔로우_ID (기본키)) — int — Primary key — NOT NULL
  • User_ID (사용자_ID (Users 테이블의 외래키)) — int — Foreign key → User.User_ID — NOT NULL
  • Artists_ID (아티스트_ID (Artists 테이블의 외래키)) — int — Foreign key → Artists.Artists_ID — NOT NULL
  • follow_date (팔로우 날짜) — date

User (Untitled)

  • User_ID (사용자_ID (기본키)) — int — Primary key — NOT NULL
  • name (사용자명) — varchar(10)
  • Email (이메일) — varchar(20)
  • password (비밀번호) — varchar(20)
  • Field (생성일) — date

Votes (Untitled5)

  • Votes_ID (투표_ID (기본키)) — int — Primary key — NOT NULL
  • User_ID (사용자_ID (Users 테이블의 외래키)) — int — Foreign key → User.User_ID — NOT NULL
  • Artists_ID (아티스트_ID (Artists 테이블의 외래키)) — int — Foreign key → Artists.Artists_ID — NOT NULL
  • vote_date (투표일) — date
  • credit_amount (사용 크레딧 양) — int