MarcWiki

Quel rôle joue une personne? est-elle membre?

mason_initiation

-- Structure de la table `mason_initiation`

DROP TABLE IF EXISTS `mason_initiation`;
CREATE TABLE IF NOT EXISTS `mason_initiation` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `id_people` int(11) unsigned NOT NULL default '0',
  `id_loge` int(11) unsigned NOT NULL default '0',
  `numero_grade` tinyint(3) NOT NULL default '1',
  `date_initiation` date NOT NULL,
  PRIMARY KEY  (`pid`),
  UNIQUE KEY `people_grade` (`id_people`,`numero_grade`),
  KEY `loge` (`id_loge`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

mason_people_statut_loge

-- Structure de la table `mason_people_statut_loge`

DROP TABLE IF EXISTS `mason_people_statut_loge`;
CREATE TABLE IF NOT EXISTS `mason_people_statut_loge` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `id_loge` int(11) unsigned NOT NULL default '0',
  `id_people` int(11) unsigned NOT NULL default '0',
  `id_statut_loge` int(11) unsigned NOT NULL default '0',
  `date_debut` date NOT NULL,
  `date_fin` date NOT NULL,
  `date_verification` date NOT NULL,
  `id_people_verificateur` int(11) unsigned NOT NULL default '0',
  `matricule_dh` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pid`),
  KEY `loge_charge` (`id_loge`,`id_statut`),
  KEY `people` (`id_people`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

mason_people_charge_loge

-- Structure de la table `mason_people_charge_loge`

DROP TABLE IF EXISTS `mason_people_charge_loge`;
CREATE TABLE IF NOT EXISTS `mason_people_charge_loge` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `id_loge` int(11) unsigned NOT NULL default '0',
  `id_people` int(11) unsigned NOT NULL default '0',
  `id_charge_loge` int(11) unsigned NOT NULL default '0',
  `ynq_member` enum('Y','N','Q') character set ascii NOT NULL,
  `date_debut` date NOT NULL,
  `date_fin` date NOT NULL,
  `us_read_level` tinyint(2) NOT NULL default '5',
  `us_write_level` tinyint(2) NOT NULL default '5',
  PRIMARY KEY  (`pid`),
  KEY `loge_charge` (`id_loge`,`id_charge_loge`),
  KEY `people` (`id_people`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

mason_people_charge_obedience

-- Structure de la table `mason_people_charge_obedience`

DROP TABLE IF EXISTS `mason_people_charge_obedience`;
CREATE TABLE IF NOT EXISTS `mason_people_charge_obedience` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `id_obedience` int(11) unsigned NOT NULL default '0',
  `id_people` int(11) unsigned NOT NULL default '0',
  `id_charge_obedience` int(11) unsigned NOT NULL default '0',
  `date_debut` date NOT NULL,
  `date_fin` date NOT NULL,
  PRIMARY KEY  (`pid`),
  KEY `people` (`id_people`),
  KEY `obedience_charge` (`id_obedience`,`id_charge_obedience`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;