Skip to content
Snippets Groups Projects
Select Git revision
  • dce1aaef442640b4af8875289f296951ddbe162d
  • master default protected
  • subtemplate
  • release_7.0.6
  • php84
  • 6.x
  • v5.x-test
  • 5x
  • 7.1.0
  • 7.0.6
  • 7.0.5
  • 7.0.4
  • 7.0.3
  • 7.0.2
  • 7.0.1
  • 7.0.0
  • 6.1.7
  • 6.1.6
  • 6.1.5
  • 6.1.4
  • 6.1.3
  • 6.1.2
  • 6.1.1
  • 6.1.0
  • 6.0.3
  • 6.0.2
  • 5.0.6
  • 6.0.1
28 results

001_tables.sql

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    001_tables.sql 1.41 KiB
    -- TABLE DES MACROS
    
    create table unicaen_renderer_macro
    (
        id serial not null constraint unicaen_document_macro_pk primary key,
        code varchar(256) not null,
        description text,
        variable_name varchar(256) not null,
        methode_name varchar(256) not null
    );
    create unique index unicaen_document_macro_code_uindex on unicaen_renderer_macro (code);
    create unique index unicaen_document_macro_id_uindex on unicaen_renderer_macro (id);
    
    -- TABLE DES TEMPLATES
    
    create table unicaen_renderer_template
    (
        id serial not null constraint unicaen_document_template_pk primary key,
        code varchar(256) not null,
        description text,
        document_type varchar(256) not null,
        document_sujet text not null,
        document_corps text not null,
        document_css text
    );
    create unique index unicaen_document_template_code_uindex on unicaen_renderer_template (code);
    create unique index unicaen_document_template_id_uindex on unicaen_renderer_template (id);
    
    -- TABLE DES RENDU
    create table unicaen_renderer_rendu
    (
        id serial not null constraint unicaen_document_rendu_pk primary key,
        template_id int default null
            constraint unicaen_document_rendu_template_id_fk
                references unicaen_renderer_template
                on delete set null,
        date_generation timestamp not null,
        sujet text not null,
        corps text not null
    );
    create unique index unicaen_document_rendu_id_uindex on unicaen_renderer_template (id);