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)