Gérer les colonnes - entreprises

← Retour

Colonnes de la table

62 colonnes
Nom Type Contraintes Défaut Actions
id 🔑
integer NOT NULL nextval('entreprises_id_seq'::regclass) 🔒
entreprise_code
character varying NOT NULL -
nom
character varying NOT NULL -
siret
character varying NOT NULL -
adresse_rue
character varying NOT NULL -
adresse_code_postal
character varying NOT NULL -
adresse_ville
character varying NOT NULL -
n_tva
character varying NOT NULL -
email
character varying NOT NULL -
pieces_active
character varying NULL -
forfait
character varying NULL -
date_creation
character varying NOT NULL -
adresse_complement
character varying NULL -
code_naf
character varying NULL -
naf_intitule
text NULL -
effectif
integer NULL -
capital
character varying NULL -
activite
text NULL -
docx_cle
character varying NULL -
docx_devis_id
character varying NULL -
docx_facture_id
character varying NULL -
docx_pv_id
character varying NULL -
docx_bdc_id
character varying NULL -
docx_ppsps_id
character varying NULL -
docx_devis_body
text NULL -
docx_facture_body
text NULL -
docx_pv_body
text NULL -
docx_bdc_body
text NULL -
docx_ppsps_body
text NULL -
tel_bureau
character varying NULL -
logo_file_id
integer NULL -
attest_assurance_file_id
integer NULL -
attest_fiscal_file_id
integer NULL -
attest_urssaf_file_id
integer NULL -
attest_travail_dissimule_file_id
integer NULL -
kbis_file_id
integer NULL -
liste_personnel_file_id
integer NULL -
adresse
text NULL -
telephone
character varying NULL -
clients_db_config
text NULL -
contact_client_db_config
text NULL -
fournisseurs_db_config
text NULL -
contact_fournisseur_db_config
text NULL -
devis_db_config
text NULL -
prestations_db_config
text NULL -
factures_db_config
text NULL -
pv_db_config
text NULL -
bons_commandes_db_config
text NULL -
ppsps_db_config
text NULL -
affaires_db_config
text NULL -
databases_created
boolean NULL -
creation_status
text NULL -
is_active
boolean NULL -
api_key
character varying NULL -
created_at
timestamp with time zone NULL now()
updated_at
timestamp with time zone NULL now()
docx_api_key
character varying NULL -
role_permissions
text NULL -
email_templates_config
text NULL '{}'::text
version
integer NULL 1
modified_by
integer NULL -
sign_api_token
character varying NULL -

Ajouter une colonne

Texte: 'valeur' | Nombre: 123 | Date: NOW()