Structure de la base de données - Revision history

Ozerhouni: Colonnes supplier_name et transaction_id et index transaction_id_idx sur supplier_bill_file

2026-09-29T08:40:58Z

Colonnes supplier_name et transaction_id et index transaction_id_idx sur supplier_bill_file

← Older revision		Revision as of 10:40, 29 September 2026
Line 1,616:		Line 1,616:
	create table supplier_bill_file		create table supplier_bill_file
	(		(
	id int unsigned auto_increment		id int unsigned auto_increment
	primary key,		primary key,
	file_type varchar(255) null,		file_type varchar(255) null,
	content longblob null,		content longblob null,
	name varchar(255) not null		name varchar(255) not null,
			supplier_name varchar(255) null,
			transaction_id varchar(255) null
	);		);

			create index transaction_id_idx
			on supplier_bill_file (transaction_id);

	create table supplier_bill_type		create table supplier_bill_type

2026-09-28T15:05:42Z

Structure

← Older revision		Revision as of 17:05, 28 September 2026
Line 1,233:		Line 1,233:
	create table profile_validity_type_join		create table profile_validity_type_join
	(		(
	profile_id bigint unsigned not null,		profile_id bigint unsigned not null,
	validity_type_id int unsigned not null,		validity_type_id int unsigned not null,
	manage4oneself int default 0 not null,		manage4oneself int default 0 not null,
	certify int default 0 not null,		certify int default 0 not null,
	optional_contract tinyint(1) default 0 not null,		optional_contract tinyint(1) default 0 not null,
			is_delete4oneself tinyint unsigned default 0 not null,
			is_delete4others tinyint unsigned default 0 not null,
	primary key (profile_id, validity_type_id)		primary key (profile_id, validity_type_id)
	);		);

2026-09-15T10:23:48Z

Structure

← Older revision		Revision as of 12:23, 15 September 2026
Line 53:		Line 53:
	)		)
	comment 'list of account entries';		comment 'list of account entries';

			create index account_id_account_date_idx
			on account_entry (account_id, account_date);

	create table account_link		create table account_link

2026-09-15T09:23:40Z

← Older revision		Revision as of 11:23, 15 September 2026
Line 114:		Line 114:
	)		)
	comment 'list of flight type';		comment 'list of flight type';

			CREATE TABLE activity_type_availability_restriction (
			id int unsigned not null auto_increment primary key,
			activity_type_id bigint unsigned not null,
			start_day tinyint unsigned not null,
			end_day tinyint unsigned not null,
			start_hour time not null,
			end_hour time not null
			)

	create table aircraft		create table aircraft
Line 1,171:		Line 1,180:
	permits2 int unsigned default 0 not null,		permits2 int unsigned default 0 not null,
	permits3 int unsigned default 0 not null,		permits3 int unsigned default 0 not null,
			permits4 int unsigned default 0 not null,
	pictogram int unsigned null,		pictogram int unsigned null,
	default_status_id int unsigned null		default_status_id int unsigned null

2026-07-07T12:11:11Z

Structure

@@ Line 597: / Line 597: @@
 create index idx_account_entry_id
      on flight_account_entry (account_entry_id);
 create table flight_hours_pricing
@@ Line 1,336: / Line 1,300: @@
      color            int unsigned                  null
 );
 create table resource_exceptional_availability

2026-07-02T14:21:30Z

Structure

@@ Line 597: / Line 597: @@
 create index idx_account_entry_id
      on flight_account_entry (account_entry_id);
 create table flight_hours_pricing

2026-06-08T11:46:06Z

Structure

← Older revision		Revision as of 13:46, 8 June 2026
Line 544:		Line 544:
	create table file		create table file
	(		(
	id int unsigned auto_increment		id int unsigned auto_increment
	primary key,		primary key,
	name varchar(255) null,		name varchar(255) null,
Line 555:		Line 555:
	parent_id int unsigned null,		parent_id int unsigned null,
	person_id int unsigned null,		person_id int unsigned null,
	~~created_at~~ datetime not null		creation_date datetime not null
	);		);

2026-06-08T08:17:55Z

Structure

← Older revision		Revision as of 10:17, 8 June 2026
Line 219:		Line 219:
	id int unsigned auto_increment		id int unsigned auto_increment
	primary key,		primary key,
	booking_group_id int unsigned null,		booking_group_id int unsigned null,
	start_date datetime null,		start_date datetime null,
	end_date datetime null		end_date datetime null,
			is_pinned tinyint unsigned default 0 null
	)		)
	comment 'records all the slots of all aircrafts of all airclubs';		comment 'records all the slots of all aircrafts of all airclubs';
Line 545:		Line 546:
	id int unsigned auto_increment		id int unsigned auto_increment
	primary key,		primary key,
	name varchar(255) null,		name varchar(255) null,
	content longblob null,		content longblob null,
	file_type varchar(255) null,		file_type varchar(255) null,
	category tinyint unsigned null,		category tinyint unsigned null,
	owner_id int null,		owner_id int null,
	file_group_id int null		file_group_id int null,
			is_current tinyint unsigned default 1 not null,
			parent_id int unsigned null,
			person_id int unsigned null,
			created_at datetime not null
	);		);

2026-05-06T14:29:17Z

Structure

@@ Line 141: / Line 141: @@
+)
      comment 'all aircrafts of all airclubs';
 create table aircraft_type
@@ Line 1,316: / Line 1,304: @@
      end_date    datetime            null,
      presence    tinyint unsigned    null
 );

2026-04-28T15:34:38Z

Structure

← Older revision		Revision as of 17:34, 28 April 2026
Line 1,593:		Line 1,593:
	rule text null,		rule text null,
	sender_email varchar(255) null,		sender_email varchar(255) null,
	subject varchar(255) null		subject varchar(255) null,
			supplier_name varchar(255) default null,
			search_keyword varchar(255) default null
	);		);