88

Tables (7)

User_Idol

  • user_id — VARCHAR(255) — Primary key — NOT NULL
  • idol_id — VARCHAR(255) — Primary key — NOT NULL
  • created_at — TIMESTAMP

artist_members

  • artist_id — BIGINT — Primary key — NOT NULL
  • group_id — BIGINT — Primary key — NOT NULL
  • joined_at — DATE
  • left_at — DATE

artists

  • Key — Primary key — NOT NULL
  • id — BIGINT
  • name — VARCHAR(120) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • agency — VARCHAR(120)
  • gender — VARCHAR(10)
  • debut_date — DATE
  • photo_url — TEXT
  • created_at — TIMESTAMP — NOT NULL

credit_transactions

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • ref_table — VARCHAR(50)
  • ref_id — BIGINT
  • provider — VARCHAR(50)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL

user_favorites

  • user_id — BIGINT — NOT NULL
  • artist_id — BIGINT — NOT NULL

users

  • user_id (id) — varchar(200) — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

wallets

  • user_id — BIGINT
  • balance_credits — BIGINT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL