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