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