1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| service_definition | CREATE TABLE `service_definition` (
`type` int(11) NOT NULL,
`service_definition_id` bigint(20) NOT NULL auto_increment,
`created_on` datetime default NULL,
`credit_for_sponsor` float default NULL,
`credit_for_sponsored` float default NULL,
`credit_on_activation` float default NULL,
`days_before_warning` int(11) default NULL,
`credit_validity_days` int(11) default NULL,
`default_service` bit(1) default NULL,
`hours_activation_failure` int(11) default NULL,
`hours_payment_failure` int(11) default NULL,
`label` varchar(45) default NULL,
`low_credit` float default NULL,
`max_credit` float default NULL,
`modified_by` varchar(128) default NULL,
`modified_on` datetime default NULL,
`months_suspend_to_inactive` int(11) default NULL,
`payment_type` int(11) default NULL,
`remote_management_type` int(11) default NULL,
`suspendable` bit(1) default NULL,
`rim_label` varchar(128) default NULL,
`company_id` bigint(20) default NULL,
`unit_type_id` bigint(20) default NULL,
PRIMARY KEY (`service_definition_id`),
KEY `modified` (`modified_on`),
KEY `FKECC5F11D6FB5C6D1` (`unit_type_id`),
KEY `FKECC5F11D31BC6F6C` (`company_id`),
CONSTRAINT `FKECC5F11D31BC6F6C` FOREIGN KEY (`company_id`) REFERENCES `company` (`company_id`),
CONSTRAINT `FKECC5F11D6FB5C6D1` FOREIGN KEY (`unit_type_id`) REFERENCES `unit_type` (`unit_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 |
Partager