1

Tables (7)

Untitled (User)

  • Key (user_id) — Primary key — NOT NULL
  • Field (email) — NOT NULL
  • Field (start_Date) — NOT NULL
  • Field (nick_name) — NOT NULL

Untitled (Artist)

  • Key (artist_id) — Primary key — NOT NULL
  • Field (artist_name) — NOT NULL
  • Field (member_number) — NOT NULL
  • Field (company) — NOT NULL

Untitled2 (Subscription)

  • Key (sub_id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (Channel_id) — Foreign key → Untitled2.Key — NOT NULL
  • Key (artist_id) — Foreign key → Untitled2.Key — NOT NULL
  • Field (User_id) — NOT NULL
  • Field (Artist_id) — NOT NULL

Untitled2 (Message)

  • Key (msg_id) — Primary key — NOT NULL
  • Key (Channel_id2) — Foreign key → Untitled2.Key — NOT NULL
  • Key (artist_id) — Foreign key → Untitled2.Key — NOT NULL
  • Field (Channel_id) — NOT NULL
  • Field (Sender_id) — NOT NULL
  • Field (send_date) — NOT NULL

Untitled2 (Channel)

  • Key (Channel_id) — Primary key — NOT NULL
  • Key (artist_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (Artist_id) — NOT NULL
  • Field (Channel_name) — NOT NULL

Untitled2 (Credit transaction)

  • Key (Trans_id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (User_id)
  • Field (amount)
  • Field (transaction_date)

Untitled2 (Notification)

  • Key (noti_id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (User_id)
  • Field (Read_ornot)