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)