<?php
//$Id$ 

include "../gen/sql/pgsql/om_tables.inc.php";

// présentation 
$ent = " om5 no code -> "._("gestion de tables et génération des objets ");
$tab_title = _("Table");
$tab_description = _("Ce listing décrit les tables existantes pour votre application");

// Filtre listing standard
$selection = " where concat(table_schema,'.') = '".DB_PREFIXE."'";
$selection .= " and substring(om_tables.table_name,1,3) not like 'om_'";
// jointure avec om_tables_parametre version 3
$table = DB_PREFIXE."om_tables left join ".
         DB_PREFIXE."om_tables_parametre on om_tables.table_name=om_tables_parametre.table_name";


$champAffiche = array(
    'om_tables.table_name as "'.__("table").'"',
    //'om_tables.table_schema as "'.__("schema").'"',
    //'om_tables.table_type as "'.__("type").'"',
    //"replace(replace(replace(replace(comment,'\"','&nbsp'),'}',''),'{',''),',','<br>') as ".'"'.__("parametres").'"',
    //"om_tables_parametre.parametres as parametres",
    "parametres->>'libelle' as libelle",
    "parametres->>'col1' as col1",
    "parametres->>'col2' as col2",
    "parametres->>'col3' as col3",
    "parametres->>'affichage' as menu",
    "parametres->>'nombre_colonne' as nb_col",
    "parametres->>'recherche' as recherche",
    );


$sousformulaire_parameters = array(
	"om_forms" => array(
		"title" => _("Formulaire"),
		),
    "om_actions" => array(
		"title" => _("Action"),
		),
	"om_contraintes" => array(
		"title" => _("clé secondaire"),
		),
    "om_triggers" => array(
		"title" => _("Trigger pgsql"),
		),

);


$sousformulaire = array(
    'om_forms',
    'om_actions',
    'om_contraintes',
    'om_triggers',
    
);