Aller au contenu principal

Cover-Logo-512x512-blue

Database Structure

Articles

TableDescriptionComment
IdId of article
NameName of articleparam definition
RefType of article1=Profile/Gasket - 2 = Accessory - 4 = Hardware - 5 = Filling
Code
DescriptionDescription of articleID of Translated Text
Affichage
Autre
Ref2SubType of article(only used for Fillings ???)
LogoImage of articleID of section for profiles/Gaskets
RefGroupRefGroup of articleId of Parent GroupArticle
SubstitutionID of substitution procedure
EmpillageID of BuilingUp procedure
VariableTree
id_condgrid_condgr of article
id_colorisationid_colorisation of article
id_paletteid_palette of article
ReferenceReference of articleReference of catalog for provider - need to match with data for import Tarif
id_raw_classpriceid_raw_classprice of article
PictureFilePictureFile of articlePath of image - relative to Provider/X2D folder
ColorGroupColorGroup of articleID of Regroupement
DocumentGroupDocumentGroup of articleID of Regroupement
ColorisationProcedureColorisationProcedure of article
Fictif
Commandable
NotProvided
MaterialProcedureMaterialProcedure of articleID of procedure (Manipulation de débit)
ViewPropertyViewProperty of article
VisibilityGroupVisibilityGroup of article
ExportInformationProcExportInformationProc of article
PerimeterIntPerimeterInt of article
PerimeterExtPerimeterExt of article
cgExportGroupcgExportGroup of article
CG_PositionCG_Position of article
cgPositioncgPosition of article
WeightWeight of article
cgBrutColorNamecgBrutColorName of article
cgMountedcgMounted of article
cgComponentcgComponent of article
cgReferenceUuidcgReferenceUuid of article

Colorisation

ID_COLORISATIONID_PALETTERESULT
10brut
21mono-interior
22mono-exterior
30bicolor