idol_Schedules

Tables (7)

IdolSchedules (Untitled7)

  • idol_schedule_id (PK) — Primary key — NOT NULL
  • idol_id (FK) — Foreign key → Idols.idol_id — NOT NULL — saedasdsad
  • schedule_id (FK2) — Foreign key → Schedules.schedule_id — NOT NULL
  • category_id (FK#) — Foreign key → Schedules.category_id — NOT NULL
  • idol_id (PK2) — Foreign key → Schedules.idol_id — NOT NULL — saedasdsad
  • role_in_schedule (Field3)

Idols (Untitled2)

  • idol_id (PK) — Primary key — NOT NULL — saedasdsad
  • name (Field)
  • type (Field2)
  • debut_date (Field3)
  • ogency (Field4)
  • profile_image_url (Field5)
  • description (Field6)

Notifications (Untitled5)

  • notification_id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → Users.user_id — NOT NULL
  • schedule_id (FK3) — Foreign key → Schedules.schedule_id — NOT NULL
  • category_id (FK2) — Foreign key → Schedules.category_id — NOT NULL
  • idol_id (PK2) — Foreign key → Schedules.idol_id — NOT NULL — saedasdsad
  • notification_time (Field3)
  • message (Field4)
  • type (Field5)
  • is_read (Field6)
  • sent_at (Field7)

ScheduleCotegories (Untitled4)

  • category_id (PK) — Primary key — NOT NULL
  • category_name (Field)
  • description (Field2)

Schedules (Untitled3)

  • schedule_id (PK) — Primary key — NOT NULL
  • category_id (FK) — Foreign key → ScheduleCotegories.category_id — NOT NULL
  • idol_id (FK2) — Foreign key → Idols.idol_id — NOT NULL — saedasdsad
  • title (Field4)
  • description (Field5)
  • start_time (Field6)
  • end_time (Field7)
  • location (Field8)
  • is_official (Field)

SociolAccounts (Untitled6)

  • sociol_account_id (PK) — Primary key — NOT NULL
  • user_id (FK) — Foreign key → Users.user_id — NOT NULL
  • provider (Field2)
  • provider_id (Field3)
  • email (Field4)
  • profile_image_url (Field6)
  • connected_at (Field7)
  • disconnected_at (Field9)

Users (Untitled)

  • user_id (PK) — Primary key — NOT NULL
  • name (Field)
  • password (Field2)
  • nickname (Field3)
  • profile_image_url (Field4)
  • role (Field5)
  • is_octive (Field6)