Fnasdom-K
Tables (7)
artists (Untitled2)
- artist_id (Key) — INT — Primary key — NOT NULL
- artist_name (Field) — VARCHAR(50)
- category (Field2) — ENUM('solo', 'group')
- group_name (Field5) — VARCHAR(50)
- agency (Field3) — VARCHAR(50)
- profile_image (Field4) — VARCHAR(255)
- gender (Field6) — ENUM('M', 'F')
credit_transactions (Untitled7)
- transaction_id (Key) — INT — Primary key — NOT NULL
- amount (Field) — DECIMAL(10,2)
- transaction_type (Field2) — ENUM('purchase', 'refund', 'vote', 'donation')
- payment_method (Field3) — ENUM('카드결제', '간편결제', '계좌이체', '무통장입금')
- transaction_at (Field4) — TIMESTAMP
- user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
danations (Untitled4)
- donation_id (Key) — INT — Primary key — NOT NULL
- amount (Field) — DECIMAL(10,2)
- donated_at (Field2) — TIMESTAMP
- Field3
- user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
- project_id (Key3) — INT — Foreign key → projects.project_id — NOT NULL
follows (Untitled6)
- follow_id (Key) — INT — Primary key — NOT NULL
- followed_at (Field) — TIMESTAMP
- Field2
- user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
- artist_id (Key3) — INT — Foreign key → artists.artist_id — NOT NULL
projects (Untitled3)
- project_id (Key) — INT — Primary key — NOT NULL
- title (Field) — VARCHAR(255)
- project_type (Field3) — ENUM('광고', '생일 서포트', '앨범 서포트', '기타')
- goal_amount (Field4) — DECIMAL(10,2)
- current_amount (Field5) — DECIMAL(10,2)
- deadline (Field6) — DATE
- projects (Field7) — ENUM('진행 중', '달성', '마감', '취소됨')
- created_at (Field8) — TIMESTAMP
- artist_id (Key2) — INT — Foreign key → artists.artist_id — NOT NULL
users (Untitled)
- user_id (Key) — INT — Primary key — NOT NULL
- username (Field) — VARCHAR(20)
- email (Field2) — VARCHAR(50)
- password (Field3) — VARCHAR(100)
- credits (Field4) — DECIMAL(10,2)
- device_type (Field5) — ENUM('PC', 'Tablet', 'Mobile')
- os_type (Field7) — ENUM('iOS', 'Android', 'Windows', 'Mac', 'Linux')
- created_at (Field6) — TIMESTAMP
votes (Untitled5)
- vote_id (Key) — INT — Primary key — NOT NULL
- vote_count (Field) — INT
- category (Field3) — ENUM('여자 아이돌', '남자 아이돌')
- vote_credits (Field4) — DECIMAL(10,2)
- voted_at (Field2) — TIMESTAMP
- user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
- artist_id (Key3) — INT — Foreign key → artists.artist_id — NOT NULL