--
-- Host: localhost    Database: exenize
-- ------------------------------------------------------


--
-- Table structure for table `budget`
--

CREATE TABLE `budget` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8mb3_unicode_ci,
  `user_id` int DEFAULT NULL,
  `producer_service` int DEFAULT NULL,
  `unexpected_cost` int DEFAULT NULL,
  `excess_cost` int DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `budget`
--


--
-- Table structure for table `budget_team`
--

CREATE TABLE `budget_team` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phase` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `items` longtext COLLATE utf8mb3_unicode_ci,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `budget_team`
--


--
-- Table structure for table `budget_team_item_detail`
--

CREATE TABLE `budget_team_item_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `budget_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `order` int DEFAULT NULL,
  `team_item_data` longtext COLLATE utf8mb3_unicode_ci,
  `item_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tax` longtext COLLATE utf8mb3_unicode_ci,
  `spent_data` longtext COLLATE utf8mb3_unicode_ci,
  `is_excluded` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `budget_team_item_detail`
--


--
-- Table structure for table `budget_team_item_name`
--

CREATE TABLE `budget_team_item_name` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `budget_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `stage` int DEFAULT NULL,
  `team_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `budget_team_item_name`
--


--
-- Table structure for table `budget_team_item_spent`
--

CREATE TABLE `budget_team_item_spent` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `budget_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `data` longtext COLLATE utf8mb3_unicode_ci,
  `item_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `budget_team_item_spent`
--


--
-- Table structure for table `calendars`
--

CREATE TABLE `calendars` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `start` date DEFAULT NULL,
  `end` date DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `daily_plan_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `calendars`
--


--
-- Table structure for table `callsheet_casts`
--

CREATE TABLE `callsheet_casts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cast_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `set` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pick_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_casts`
--


--
-- Table structure for table `callsheet_check_cast`
--

CREATE TABLE `callsheet_check_cast` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_id` int DEFAULT NULL,
  `callsheet_cast_id` int DEFAULT NULL,
  `cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `role` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `set` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_check_cast`
--


--
-- Table structure for table `callsheet_check_datas`
--

CREATE TABLE `callsheet_check_datas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_id` int DEFAULT NULL,
  `info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extra_notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoot_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `weather` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `call` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `call_info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `break` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `break_info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `breakfast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `breakfast_info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `finish` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `finish_info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_check_datas`
--


--
-- Table structure for table `callsheet_check_pickup`
--

CREATE TABLE `callsheet_check_pickup` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_id` int DEFAULT NULL,
  `callsheet_pickup_id` int DEFAULT NULL,
  `crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pickup` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `set` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_check_pickup`
--


--
-- Table structure for table `callsheet_check_scene`
--

CREATE TABLE `callsheet_check_scene` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` int DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fgr` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `page` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n_i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `synopsis` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `equipment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_check_scene`
--


--
-- Table structure for table `callsheet_check_second_scenes`
--

CREATE TABLE `callsheet_check_second_scenes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` int DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fgr` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `page` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n_i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `synopsis` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `equipment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_check_second_scenes`
--


--
-- Table structure for table `callsheet_datas`
--

CREATE TABLE `callsheet_datas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `info` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extra_notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `shoot_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `weather` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `call` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `break` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `breakfast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `finish` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_datas`
--


--
-- Table structure for table `callsheet_pickups`
--

CREATE TABLE `callsheet_pickups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `pickup` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `set` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_pickups`
--


--
-- Table structure for table `callsheet_scenes`
--

CREATE TABLE `callsheet_scenes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fgr` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `page` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n_i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `synopsis` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `equipment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_scenes`
--


--
-- Table structure for table `callsheet_second_scenes`
--

CREATE TABLE `callsheet_second_scenes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `callsheet_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fgr` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `page` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n_i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `synopsis` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `equipment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `plan_ready` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `hair_make_up` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheet_second_scenes`
--


--
-- Table structure for table `callsheets`
--

CREATE TABLE `callsheets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `callsheets`
--


--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `exclude_scenes_on_daily_plan` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `config`
--


--
-- Table structure for table `crew_suggestion`
--

CREATE TABLE `crew_suggestion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `suggestion` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `crew_suggestion`
--


--
-- Table structure for table `crews`
--

CREATE TABLE `crews` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `department` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `blood_type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `id_number` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `insurance_number` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `crews`
--


--
-- Table structure for table `daily_plan`
--

CREATE TABLE `daily_plan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `shoot_date` date DEFAULT NULL,
  `shoot_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_alternative` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `daily_plan`
--


--
-- Table structure for table `daily_plan_notes`
--

CREATE TABLE `daily_plan_notes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `daily_plan_id` int DEFAULT NULL,
  `note_detail` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `note_header` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `daily_plan_notes`
--


--
-- Table structure for table `daily_plan_script_breakdown`
--

CREATE TABLE `daily_plan_script_breakdown` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `crew_no` int DEFAULT NULL,
  `order` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `daily_plan_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `script_breakdown_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `daily_plan_script_breakdown`
--


--
-- Table structure for table `daily_plan_suggestion`
--

CREATE TABLE `daily_plan_suggestion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `suggestion` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `daily_plan_suggestion`
--


--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `type` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cover` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cover_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `department`
--


--
-- Table structure for table `department_files`
--

CREATE TABLE `department_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `department_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extension` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `department_files`
--


--
-- Table structure for table `expense_detail`
--

CREATE TABLE `expense_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `expense_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `expense_detail`
--


--
-- Table structure for table `expense_detail_files`
--

CREATE TABLE `expense_detail_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `expense_detail_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extension` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `expense_detail_files`
--


--
-- Table structure for table `expense_suggestion`
--

CREATE TABLE `expense_suggestion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `suggestion` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `expense_suggestion`
--


--
-- Table structure for table `expense_types`
--

CREATE TABLE `expense_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `expense_types`
--


--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `expense` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `department` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `type` int DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `spent_date` date DEFAULT NULL,
  `expense_close_date` date DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `expenses`
--


--
-- Table structure for table `identities`
--

CREATE TABLE `identities` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `project_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `producer` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cast` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `art_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `production_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `camera_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `costume_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `light_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sound_crew` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `director` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `script` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `writer` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `dop` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `editing` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `music` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `aspect` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `language` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `format` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `graphic` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `special_effect` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `sound_design` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `identity_image_web` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `identity_image` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company_image_web` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `company_image` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `identities`
--


--
-- Table structure for table `location_files`
--

CREATE TABLE `location_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `location_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `attachment_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extension` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `location_files`
--


--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `notes` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `map` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `locations`
--


--
-- Table structure for table `match_storyboard_script_breakdown`
--

CREATE TABLE `match_storyboard_script_breakdown` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `storyboard_id` int DEFAULT NULL,
  `script_breakdown_id` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `match_storyboard_script_breakdown`
--


--
-- Table structure for table `migration`
--

CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `migration`
--

INSERT INTO `migration` VALUES ('m000000_000000_base',1702737312),('m231210_112037_create_exenize_db',1702737322),('m231216_145811_create_signup_token_table',1702738885),('m231216_182258_create_user',1702752658),('m231216_201551_add_new_migration',1702758431),('m240316_110739_create_admin_table',1710588110),('m240316_111233_timeline_event',1710588159);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `type` int DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `package_usage`
--

CREATE TABLE `package_usage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `package_id` int DEFAULT NULL,
  `project` int DEFAULT NULL,
  `crew` int DEFAULT NULL,
  `callsheet` int DEFAULT NULL,
  `script_breakdown` int DEFAULT NULL,
  `expenses` int DEFAULT NULL,
  `storyboard` int DEFAULT NULL,
  `scenario` int DEFAULT NULL,
  `report` int DEFAULT NULL,
  `type` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `package_usage`
--

INSERT INTO `package_usage` VALUES (1,1,1,1,0,0,0,0,0,0,NULL,NULL,1702752658,NULL,1702753141,1,NULL,NULL),(2,6,1,1,0,0,0,0,0,0,NULL,NULL,1703355586,NULL,1703430278,6,NULL,NULL),(3,7,1,1,0,0,0,0,0,0,NULL,NULL,1703438990,NULL,1710610802,7,NULL,NULL);

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `package_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `project` int DEFAULT NULL,
  `crew` int DEFAULT NULL,
  `callsheet` int DEFAULT NULL,
  `script_breakdown` int DEFAULT NULL,
  `expenses` int DEFAULT NULL,
  `storyboard` int DEFAULT NULL,
  `scenario` int DEFAULT NULL,
  `report` int DEFAULT NULL,
  `type` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` VALUES (1,'Generous',500,500000,500000,500000,500000,500000,500000,500000,3,NULL,NULL,NULL,NULL);

--
-- Table structure for table `panel_todo`
--

CREATE TABLE `panel_todo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `panel_todo`
--

INSERT INTO `panel_todo` VALUES (1,3,'WVU2DvARzfE8WR7HVTqSx9yL6z3sTO_H1710610869','asd',NULL,NULL,NULL,NULL);

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `director` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `producer` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` VALUES (1,'Deneme','BxIvRlP9iuB3o1zgqW2pCfxZb0wBdebf1702753141','a','b',1702753141,1,1702753141,1),(2,'New Project','cU5qb5AgLHhdaOG_ycf0BtlXxu0ZhWCN1703430278','ali','ali',1703430278,6,1703430278,6),(3,'Yeni Proje','pqunolEqP_gVUxCpiFO3bV6wnyHjL-RT1710610802','Barış','Fert',1710610802,7,1710610802,7);

--
-- Table structure for table `scenarios`
--

CREATE TABLE `scenarios` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `project_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `header` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file_web_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `extension` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `scenarios`
--


--
-- Table structure for table `script_breakdown`
--

CREATE TABLE `script_breakdown` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `project_id` int DEFAULT NULL,
  `scene_note` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` int DEFAULT NULL,
  `episode` int DEFAULT NULL,
  `place` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `d_n` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `i_e` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode_note` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scenario_day` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cast` longtext COLLATE utf8mb3_unicode_ci,
  `equipment` longtext COLLATE utf8mb3_unicode_ci,
  `costume` longtext COLLATE utf8mb3_unicode_ci,
  `hair_make_up` longtext COLLATE utf8mb3_unicode_ci,
  `fgr` longtext COLLATE utf8mb3_unicode_ci,
  `page` longtext COLLATE utf8mb3_unicode_ci,
  `synopsis` longtext COLLATE utf8mb3_unicode_ci,
  `full_scene_text` longtext COLLATE utf8mb3_unicode_ci,
  `done` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `script_breakdown`
--


--
-- Table structure for table `script_breakdown_suggestion`
--

CREATE TABLE `script_breakdown_suggestion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `suggestion` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `script_breakdown_suggestion`
--


--
-- Table structure for table `storyboards`
--

CREATE TABLE `storyboards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `scene_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `width` int DEFAULT NULL,
  `height` int DEFAULT NULL,
  `ratio` int DEFAULT NULL,
  `plan_no` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `episode` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `image_web_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `deleted_at` int DEFAULT NULL,
  `deleted_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `storyboards`
--


--
-- Table structure for table `tax_list`
--

CREATE TABLE `tax_list` (
  `id` int NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `budget_id` int DEFAULT NULL,
  `tax` int DEFAULT NULL,
  `type` int DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tax_list`
--


--
-- Table structure for table `timeline_event`
--

CREATE TABLE `timeline_event` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `data` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `event` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `category` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `timeline_event`
--

INSERT INTO `timeline_event` VALUES (1,3,'{\"user\":\"ufuk\",\"identifier\":\"asd\",\"slug\":\"\"}','create','panel',1710610869,NULL,NULL,NULL);

--
-- Table structure for table `todo_task`
--

CREATE TABLE `todo_task` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `tab_active` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `panel_todo_id` int DEFAULT NULL,
  `tab_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `detail` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cover` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `cover_filename` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `is_done` tinyint(1) DEFAULT NULL,
  `file` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `todo_task`
--


--
-- Table structure for table `user_allowed_function`
--

CREATE TABLE `user_allowed_function` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `team_user_id` int DEFAULT NULL,
  `admin_user` int DEFAULT NULL,
  `crew` tinyint(1) DEFAULT NULL,
  `script_breakdown` tinyint(1) DEFAULT NULL,
  `callsheet` tinyint(1) DEFAULT NULL,
  `calendar` tinyint(1) DEFAULT NULL,
  `expense` tinyint(1) DEFAULT NULL,
  `identity` tinyint(1) DEFAULT NULL,
  `scenario` tinyint(1) DEFAULT NULL,
  `storyboard` tinyint(1) DEFAULT NULL,
  `todo` tinyint(1) DEFAULT NULL,
  `budget` tinyint(1) DEFAULT NULL,
  `report` tinyint(1) DEFAULT NULL,
  `daily_plan` tinyint(1) DEFAULT NULL,
  `user_allowed_function` tinyint(1) DEFAULT NULL,
  `timeline_event` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `user_allowed_function`
--


--
-- Table structure for table `user_allowed_panel_todo`
--

CREATE TABLE `user_allowed_panel_todo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `team_user_id` int DEFAULT NULL,
  `panel_todo_slug` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `user_allowed_panel_todo`
--


--
-- Table structure for table `users_projects`
--

CREATE TABLE `users_projects` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `role` int DEFAULT NULL,
  `user_allowed_function_id` int DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `users_projects`
--

INSERT INTO `users_projects` VALUES (1,1,1,1,NULL,1,1702753141,NULL,NULL,NULL),(2,2,6,1,NULL,1,1703430278,NULL,NULL,NULL),(3,3,7,1,NULL,1,1710610802,NULL,NULL,NULL);


