fandomk

Tables (8)

Artists

  • Artists아이디 (id) — INT — Primary key — NOT NULL
  • 아티스트이름 (artists_name) — VARCHAR(100)
  • 아티스트아이디 (artist_id) — VARCHAR(20)
  • 그룹명 (group_name) — VARCHAR(50)
  • 성별 (gender) — CHAR(1)
  • 나이 (age) — INT

Credits

  • Credits아이디 (id) — INT — Primary key — NOT NULL
  • User아이디 (user_id) — INT — Foreign key → User.User아이디 — NOT NULL
  • 날짜 (date) — DATETIME
  • 사용패턴 (use_pattern) — CHAR(10)
  • 총크레딧 (total_credit) — INT
  • 크레딧 (credit) — INT

Follow

  • follow아이디 (id) — INT — Primary key — NOT NULL
  • User아이디 (user_id) — INT — Foreign key → User.User아이디 — NOT NULL
  • Artists아이디 (artist_id) — INT — Foreign key → Artists.Artists아이디 — NOT NULL
  • 팔로우날짜 (created_at) — DATETIME
  • 팔로우상태 (is_active) — BOOLEAN

Sales

  • Sales아이디 (id) — INT — Primary key — NOT NULL
  • Credits아이디 (credit_id) — INT — Foreign key → Credits.Credits아이디 — NOT NULL
  • 날짜 (date) — DATETIME
  • 크레딧_원화환전율 (rate) — DECIMAL
  • 원화계산 (to_won_conv) — DECIMAL
  • 수수료율 (commission_rate) — DECIMAL
  • 실매출 (actual_sales) — DECIMAL

Sponsor (Sponser)

  • Sponsor아이디 (id) — INT — Primary key — NOT NULL
  • User아이디 (user_id) — INT — Foreign key → User.User아이디 — NOT NULL
  • 조공아이디 (tribute_id) — INT — Foreign key → Tribute.조공아이디 — NOT NULL
  • 후원날짜 (created_at) — DATETIME

Tribute

  • 조공아이디 (id) — INT — Primary key — NOT NULL
  • Artists아이디 (artist_id) — INT — Foreign key → Artists.Artists아이디 — NOT NULL
  • 조공이름 (tribute_name) — VARCHAR(30)
  • 조공분류 (category) — VARCHAR(10)
  • 목표크레딧 (target_credit) — INT
  • 시작날짜 (start_at) — DATETIME
  • 마감날짜 (deadline) — DATETIME
  • 후원상태 (status) — VARCHAR(10)

User

  • User아이디 (id) — INT — Primary key — NOT NULL
  • 사용자아이디 (user_id) — VARCHAR(20)
  • 비밀번호 (password) — VARCHAR(20)
  • 사용자이름 (user_name) — VARCHAR(50)
  • 나이 (age) — INT
  • 성별 (gender) — CHAR(1)
  • email — VARCHAR(30)
  • 전화번호 (phone_num) — VARCHAR(20)
  • 주소 (addresss) — VARCHAR(100)

Vote

  • 투표아이디 (id) — INT — Primary key — NOT NULL
  • User아이디 (user_id) — INT — Foreign key → User.User아이디 — NOT NULL
  • Artists아이디 (artist_id) — INT — Foreign key → Artists.Artists아이디 — NOT NULL
  • 투표시간 (created_at) — DATETIME
  • 투표수 (vote_count) — INT