Membership
- Dart
- Laravel
Description
- - -name: varchar(255) NOT NULL,
- - - description
// add as a subcollection of profiles or add profile ID here
- - - `primary_price` int(11) NOT NULL,
- - - `image` varchar(255) NOT NULL,
- - - `time` varchar(255) NOT NULL,
- - - `type` varchar(255) NOT NULL,
- - - `no_of_device` int(11) NOT NULL,
- - - `size_of_data_upload` varchar(255) NOT NULL COMMENT 'MB',
- - - `android_product_package` varchar(255) NOT NULL,
- - - `ios_product_package` varchar(255) NOT NULL,
- - - `web_product_package` varchar(255) NOT NULL,
- - - `status` int(11) NOT NULL DEFAULT 1,
- - - `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
- - - `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
- custom_prices
- - price_#1
- - - Regons
- USA
- Canada
- - - curency (USD)
- - - price ($0.00)
- - - tax (00%)
- benifites
- - benifit 1
- - - benifit id
Benifits
- benifits
-
- benifit #1
-
-
- benifit type (content, feature)
-
-
-
- title (early access, downlaods, less ads, no ads, background play, varified account, etc)
-
-
-
- description
-
-
-
- feature key (ID)
-
-- Table structure for table `tbl_package`
--
CREATE TABLE `tbl_package` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`price` int(11) NOT NULL,
`image` varchar(255) NOT NULL,
`time` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`no_of_device` int(11) NOT NULL,
`size_of_data_upload` varchar(255) NOT NULL COMMENT 'MB',
`ads_free` int(11) NOT NULL,
`download` int(11) NOT NULL,
`background_play` int(11) NOT NULL,
`verifly_artist` int(11) NOT NULL,
`verifly_account` int(11) NOT NULL,
`android_product_package` varchar(255) NOT NULL,
`ios_product_package` varchar(255) NOT NULL,
`web_product_package` varchar(255) NOT NULL,
`status` int(11) NOT NULL DEFAULT 1,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;