Structure de la base de données - Revision history

Claratte: /* Structure */

2024-10-14T12:56:09Z

Structure

← Older revision		Revision as of 14:56, 14 October 2024
Line 1,655:		Line 1,655:
	`number_of_sessions` int(11) NOT NULL,		`number_of_sessions` int(11) NOT NULL,
	`order_num` int(11) NOT NULL AUTO_INCREMENT,		`order_num` int(11) NOT NULL AUTO_INCREMENT,
	`custom_label` ~~VARCHAR~~(255),		`custom_label` varchar(255),
	PRIMARY KEY (`training_id`,`training_item_label_id`),		PRIMARY KEY (`training_id`,`training_item_label_id`),
	KEY `order_num_idx` (`order_num` ASC),		KEY `order_num_idx` (`order_num` ASC),

Claratte: /* Structure */

2024-10-14T12:55:25Z

Structure

← Older revision		Revision as of 14:55, 14 October 2024
Line 1,655:		Line 1,655:
	`number_of_sessions` int(11) NOT NULL,		`number_of_sessions` int(11) NOT NULL,
	`order_num` int(11) NOT NULL AUTO_INCREMENT,		`order_num` int(11) NOT NULL AUTO_INCREMENT,
			`custom_label` VARCHAR(255),
	PRIMARY KEY (`training_id`,`training_item_label_id`),		PRIMARY KEY (`training_id`,`training_item_label_id`),
	KEY `order_num_idx` (`order_num` ASC),		KEY `order_num_idx` (`order_num` ASC),

Claratte: /* Structure */

2024-10-14T12:43:41Z

Structure

← Older revision		Revision as of 14:43, 14 October 2024
Line 2:		Line 2:

	=Structure=		=Structure=
			<syntaxhighlight lang="sql">
	<sql>create table account		create table account
	(		(
	id int unsigned auto_increment		id int unsigned auto_increment
Line 2,100:		Line 2,100:

	RETURN totalBalance;		RETURN totalBalance;
	END;</~~sql~~>		END;
			</syntaxhighlight>

	=Description=		=Description=

imported>Claratte: /* Structure */

2024-01-10T14:25:10Z

Structure

← Older revision		Revision as of 16:25, 10 January 2024
Line 1,637:		Line 1,637:

	CREATE TABLE `training_program_activity` (		CREATE TABLE `training_program_activity` (
	`training_program_id` int(10) unsigned NOT NULL,		`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	`activity_type_id` bigint(20) unsigned NOT NULL,		`training_program_id` int(10) unsigned NOT NULL,
	`duration` int(11) unsigned DEFAULT NULL,		`activity_type_id` bigint(20) unsigned NOT NULL,
	`breaktime` int(11) unsigned DEFAULT NULL,		`duration` int(11) unsigned DEFAULT NULL,
	`order_num` int(11) unsigned NOT NULL,		`breaktime` int(11) unsigned DEFAULT NULL,
	PRIMARY KEY (`~~training_program_id`, `activity_type_id~~`),		`order_num` int(11) unsigned NOT NULL,
	KEY `training_program_id_idx` (`training_program_id`),		PRIMARY KEY (`id`),
	KEY `activity_type_id_idx` (`activity_type_id`),		KEY `training_program_id_idx` (`training_program_id`),
	CONSTRAINT `training_program_activity_activity_type_id_fk` FOREIGN KEY (`activity_type_id`) REFERENCES `activity_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,		KEY `activity_type_id_idx` (`activity_type_id`),
	CONSTRAINT `training_program_activity_training_program_id_fk` FOREIGN KEY (`training_program_id`) REFERENCES `training_program` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION		CONSTRAINT `training_program_activity_activity_type_id_fk` FOREIGN KEY (`activity_type_id`) REFERENCES `activity_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
			CONSTRAINT `training_program_activity_training_program_id_fk` FOREIGN KEY (`training_program_id`) REFERENCES `training_program` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
	);		);

imported>Claratte: /* Structure */

2023-06-22T17:34:16Z

Structure

← Older revision		Revision as of 19:34, 22 June 2023
Line 250:		Line 250:
	resource_id int unsigned default 0 not null,		resource_id int unsigned default 0 not null,
	primary key (booking_id, resource_id)		primary key (booking_id, resource_id)
			);

			CREATE TABLE `booking_training_program` (
			`booking_group_id` int(10) unsigned NOT NULL,
			`training_program_id` int(10) unsigned NOT NULL,
			PRIMARY KEY (`booking_group_id`,`training_program_id`),
			CONSTRAINT `booking_training_program_training_program_id_fk` FOREIGN KEY (`training_program_id`) REFERENCES `training_program` (`id`)
	);		);

imported>Claratte: /* Structure */

2023-05-25T11:33:17Z

Structure

← Older revision		Revision as of 13:33, 25 May 2023
Line 1,562:		Line 1,562:
	primary key,		primary key,
	name varchar(255) not null		name varchar(255) not null
			);

			CREATE TABLE `training` (
			`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
			`name` varchar(255) NOT NULL,
			PRIMARY KEY (`id`)
	);		);

Line 1,615:		Line 1,621:

	CREATE TABLE `training_program` (		CREATE TABLE `training_program` (
	`id` int(10) unsigned NOT NULL,		`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	`name` varchar(255) NOT NULL,		`training_id` int(10) unsigned DEFAULT NULL,
	PRIMARY KEY (`id`)		`name` varchar(255) NOT NULL,
			PRIMARY KEY (`id`),
			KEY `training_id_idx` (`training_id`),
			CONSTRAINT `training_program_training_id_fk` FOREIGN KEY (`training_id`) REFERENCES `training` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
			);

			CREATE TABLE `training_program_activity` (
			`training_program_id` int(10) unsigned NOT NULL,
			`activity_type_id` bigint(20) unsigned NOT NULL,
			`duration` int(11) unsigned DEFAULT NULL,
			`breaktime` int(11) unsigned DEFAULT NULL,
			`order_num` int(11) unsigned NOT NULL,
			PRIMARY KEY (`training_program_id`, `activity_type_id`),
			KEY `training_program_id_idx` (`training_program_id`),
			KEY `activity_type_id_idx` (`activity_type_id`),
			CONSTRAINT `training_program_activity_activity_type_id_fk` FOREIGN KEY (`activity_type_id`) REFERENCES `activity_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
			CONSTRAINT `training_program_activity_training_program_id_fk` FOREIGN KEY (`training_program_id`) REFERENCES `training_program` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
	);		);

	CREATE TABLE `~~training_program_item~~` (		CREATE TABLE `training_item` (
	`~~training_program_id~~` int(10) unsigned NOT NULL,		`training_id` int(10) unsigned NOT NULL,
	`~~training_item_id~~` int(10) unsigned NOT NULL,		`training_item_label_id` int(10) unsigned NOT NULL,
	`number_of_sessions` int(11) NOT NULL,		`number_of_sessions` int(11) NOT NULL,
	`order_num` int(11) NOT NULL,		`order_num` int(11) NOT NULL AUTO_INCREMENT,
	PRIMARY KEY (`~~training_program_id~~`,`~~training_item_id~~`),		PRIMARY KEY (`training_id`,`training_item_label_id`),
	CONSTRAINT `~~training_program_item_training_program_id_fk~~` FOREIGN KEY (`~~training_program_id~~`) REFERENCES `~~training_program~~` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION		KEY `order_num_idx` (`order_num` ASC),
			CONSTRAINT `training_item_training_id_fk` FOREIGN KEY (`training_id`) REFERENCES `training` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
	);		);

imported>Claratte: /* Structure */

2023-04-13T16:57:53Z

Structure

← Older revision		Revision as of 18:57, 13 April 2023
Line 631:		Line 631:
	);		);

	~~create table~~ flight_track		CREATE TABLE `flight_track` (
	(		`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	id int unsigned ~~auto_increment~~		`flight_id` int(10) NOT NULL,
	~~primary key~~,		`track` mediumblob NOT NULL,
	flight_id int(10) ~~not null~~,		`file_type` varchar(255) DEFAULT 'kml',
	track mediumblob ~~not null~~		PRIMARY KEY (`id`)
	);		);

imported>Claratte: /* Structure */

2023-03-22T17:54:47Z

Structure

← Older revision		Revision as of 19:54, 22 March 2023
Line 989:		Line 989:
	primary key (code, key_id)		primary key (code, key_id)
	);		);

	~~create table payment_distribution~~
	(
	~~payment_id int unsigned default 0 not null~~
	~~primary key,~~
	~~account_club_id int unsigned null,~~
	~~person_delivery tinyint(1) unsigned default 0 null,~~
	~~member_budget_id int unsigned null,~~
	~~treasury_budget_id int unsigned null~~
	)
	~~comment 'payment distribution description';~~

	create table payment_summary_file		create table payment_summary_file
Line 1,013:		Line 1,002:
	);		);

	~~create table~~ payment_type		CREATE TABLE `payment_type` (
	(		`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	id int unsigned ~~auto_increment~~		`name` text,
	~~primary key~~,		`text_field_label` text,
	name text ~~null~~,		`only_admin` tinyint(1) unsigned NOT NULL DEFAULT '0',
	text_field_label text ~~null~~,		`pos_key_id` int(10) unsigned DEFAULT NULL,
	only_admin tinyint(1) unsigned ~~default~~ 0 ~~not null~~,		`treasury_account_id` int(10) unsigned DEFAULT NULL,
	~~order_num~~ int ~~null~~,		`person_delivery` tinyint(1) unsigned DEFAULT '0',
	~~pos_key_id~~ int unsigned ~~null~~		`person_budget_id` int(10) unsigned DEFAULT NULL,
	)		`treasury_budget_id` int(10) unsigned DEFAULT NULL,
	~~comment~~ 'type of payment description';		`minimum_amount` decimal(10,0) DEFAULT NULL,
			`maximum_amount` decimal(10,0) DEFAULT NULL,
			PRIMARY KEY (`id`)
			) COMMENT='type of payment description';

	create table person		create table person

imported>Claratte: /* Structure */

2023-03-08T14:34:24Z

Structure

← Older revision		Revision as of 16:34, 8 March 2023
Line 26:		Line 26:
	on account (owner_id);		on account (owner_id);

	~~create table~~ account_entry		CREATE TABLE `account_entry` (
	(		`id` int(11) NOT NULL AUTO_INCREMENT,
	id int ~~auto_increment~~		`flow_id` int(11) DEFAULT NULL,
	~~primary key~~,		`account_date` datetime DEFAULT NULL,
	flow_id int ~~null~~,		`account_id` int(11) DEFAULT NULL,
	account_date datetime ~~null~~,		`credit` decimal(15,5) DEFAULT '0.00000',
	account_id int ~~null~~,		`debit` decimal(15,5) DEFAULT '0.00000',
	credit decimal(15, 5) ~~default~~ 0.00000 ~~null~~,		`payment_type` int(10) unsigned DEFAULT NULL,
	debit decimal(15, 5) ~~default~~ 0.00000 ~~null~~,		`payment_description` text,
	payment_type int unsigned ~~null~~,		`person_delivery_id` int(10) unsigned DEFAULT NULL,
	payment_description text ~~null~~,		`comments` text,
	person_delivery_id int unsigned ~~null~~,		`validated` int(1) DEFAULT '0',
	comments text ~~null~~,		`exported` int(1) DEFAULT '0',
	validated int(1) ~~default~~ 0 ~~null~~,		`registration_date` datetime DEFAULT NULL,
	exported int(1) ~~default~~ 0 ~~null~~,		`budget_id` int(10) unsigned DEFAULT NULL,
	registration_date datetime ~~null~~,		`product_id` int(10) unsigned DEFAULT NULL,
	budget_id int unsigned ~~null~~,		`signature` varchar(56) DEFAULT NULL,
	product_id int unsigned ~~null~~,		`signature_date` bigint(13) unsigned DEFAULT NULL,
	signature varchar(56) ~~null~~,		`lettering` int(11) DEFAULT NULL,
	signature_date bigint(13) unsigned ~~null~~,		`lettering_date` datetime DEFAULT NULL,
	lettering int ~~null~~,		`flow_reversal_id` int(10) unsigned DEFAULT NULL,
	lettering_date datetime ~~null~~		`transaction_id` text,
	)		PRIMARY KEY (`id`),
	~~comment 'List of account entries';~~		KEY `idx_flow_id` (`flow_id`),
			KEY `idx_account_date` (`account_date`),
	~~create index idx_account_date~~		KEY `idx_signature_date` (`signature_date`),
	~~on account_entry~~ (~~account_date~~);		KEY `flow_reversal_id_idx` (`flow_reversal_id`)
			);
	~~create index~~ idx_flow_id
	~~on account_entry~~ (flow_id);

	~~create index~~ idx_signature_date
	~~on account_entry~~ (~~signature_date~~);

	create table account_link		create table account_link

imported>Claratte: /* Structure */

2022-10-24T14:40:54Z

Structure

@@ Line 103: / Line 103: @@
      profile_id    bigint unsigned default 0 not null,
      primary key (accounting_id, profile_id)
 );