GraphicModel-SubInfo-FillBase-Color
Tables (20)
Bilp Fill (BLIPFILL)
- fill base (FILLBASEID) — number — Foreign key → FillBase.fill base — NOT NULL
Color (COLOR)
- color id (COLORID) — number — Primary key — NOT NULL
- color type (COLORTYPE) — varchar(20)
- color transform (COLORTRNASFORM) — varchar(1000)
Effect property info (EFFECTINFO)
- Document ID (DOCUMENTID) — number — Foreign key → New shapeModel.Document ID — NOT NULL
- Element ID (ELEMENTID) — number — Foreign key → New shapeModel.Element ID — NOT NULL
- outer shadow (OUTERSHDW) — varchar(20)
- inner shadow (INNERSHDW) — varchar(20)
- reflection (REFLECTION) — varchar(20)
- glow (GLOW) — varchar(20)
- soft edge (SOFTEDGE) — varchar(20)
Fill property info (FILLINFO)
- Document ID (DOCUMENTID) — number — Foreign key → New shapeModel.Document ID — NOT NULL
- Element ID (ELEMENTID) — number — Foreign key → New shapeModel.Element ID — NOT NULL
- fill base (FILLBASEID) — number — Foreign key → FillBase.fill base — NOT NULL
FillBase (FILLBASE)
- fill base (FILLBASEID) — number — Primary key — NOT NULL
- Fill type (FIllTYPE) — varchar(20)
Gradient Fill (GRADIENTFILL)
- fill base (FILLBASEID) — number — Foreign key → FillBase.fill base — NOT NULL
- gradient stops (GRDSTOPLST) — varchar(255)
Gradient Stop (GARDIENTSTOP)
- gradient stop id (GSID) — Primary key — NOT NULL
- color id (COLORID) — number — Foreign key → Color.color id — NOT NULL
HSL Color (HSLCOLOR)
- color id (COLORID) — number — Foreign key → Color.color id — NOT NULL
- hue (HUE) — number(3)
- saturation (SAT) — number(3)
- luminance (LUM) — number(3)
New shapeModel (OFFICE_SHAPE_ELEMENT_NEW)
- Document ID (DOCUMENTID) — number — Primary key — NOT NULL
- Element ID (ELEMENTID) — number — Primary key — NOT NULL
- content data (CONTENTDATA) — CLOB
- common shape style ID (COMMONSHAPESTYLEID) — varchar(20)
No Fill (NOFILL)
- fill base (FILLBASEID) — number — Foreign key → FillBase.fill base — NOT NULL
OLD shapeModel (fill info only) (OFFICE_SHAPE_ELEMENT)
- Document ID (DOCUMENTID) — number — Primary key — NOT NULL
- Element ID (ELEMENTID) — number — Primary key — NOT NULL
- content data (CONTENTDATA) — CLOB
- common shape style ID (COMMONSHAPESTYLEID) — varchar(20)
- no fill (NOFILL) — varchar(1)
- solid fill (SOLIDFILL) — varchar(1)
- solid fill color (SOLIDFILLCOLOR) — varchar(200)
- pattern fill (PATTERNFILL) — varchar(1)
- pattern preset (PATTERNFILLPRST) — varchar(1)
- pattern fg color (PATTERNFILLFOREGROUNDCOLOR) — varchar(200)
- pattern bg color (PATTERNFILLBACKGROUNDCOLOR) — varchar(200)
- gradient fill (GRADIENTFILL) — varchar(1)
- gradient rotate with shape (GRADIENTFILLROTWITHSHAPE) — varchar(1)
- gradient stop list (GRADIENTFILLSTOPLIST) — varchar(1000)
- gradient path type (GRADIENTFILLPATHTYPE) — varchar(10)
- gradient path rect left (GRADIENTFILLPATHRECTL) — varchar(10)
- gradient path rect top (GRADIENTFILLPATHRECTT) — varchar(10)
- gradient path rect right (GRADIENTFILLPATHRECTR) — varchar(10)
- gradient path rect bottom (GRADIENTFILLPATHRECTB) — varchar(10)
- gradient linear angle (GRADIENTFILLLINEARANGLE) — number(10)
- gradient linear scaled (GRADIENTFILLLINEARSCALED) — varchar(1)
- gradient tile rect left (GRADIENTFILLTILERECTL) — varchar(10)
- gradient tile rect top (GRADIENTFILLTILERECTT) — varchar(10)
- gradient tile rect right (GRADIENTFILLTILERECTR) — varchar(10)
- gradient tile rect bottom (GRADIENTFILLTILERECTB) — varchar(10)
- blip fill (BLIPFILL) — varchar(1)
- blip multimedia unique id (BLIPFILLMULTIMEDIAUNIQUEID) — varchar(100)
- blip alpha bi level (BLIPFILLALPHABILEVEL) — number(10)
- blip alpha ceiling (BLIPFILLALPHACEILING) — varchar(30)
- blip alpha floor (BLIPFILLALPHAFLOOR) — varchar(30)
- blip alpha inverse (BLIPFILLALPHAINV) — varchar(30)
- blip alpha modulation (BLIPFILLALPHAMOD) — varchar(30)
- blip alpha mod fixed value (BLIPFILLALPHAMODFIX) — varchar(30)
- blip alpha replace effect (BLIPFILLALPHAREPL) — varchar(30)
- blip bi level (BLIPFILLBILEVEL) — varchar(30)
- blip blur radius (BLIPFILLBLURRAD) — number(10)
- blip blur grow (BLIPFILLBLURGROW) — varchar(30)
- blip blur color change (BLIPFILLBLURCLRCHANGE) — varchar(30)
- blip blur color replace (BLIPFILLBLURCLRREPL) — varchar(30)
- blip duotone (BLIPFILLDUOTONE) — varchar(30)
- blip overlay (BLIPFILLOVERLAY) — varchar(30)
- blip grayscale (BLIPFILLGRAYSCL) — varchar(30)
- blip hue (BLIPFILLHUE) — number(10)
- blip saturation (BLIPFILLSATURATION) — number(10)
- blip lightness (BLIPFILLLIGHTNESS) — number(10)
- blip lum contrast (BLIPFILLLUMCONTRAST) — number(10)
- blip lum brightness (BLIPFILLLUMBRIGHT) — number(10)
- blip tint hue (BLIPFILLTINTHUE) — number(10)
- blip tint amount (BLIPFILLTINTAMT) — number(10)
- blip extent list (BLIPFILLBLIPEXTLST) — varchar(30)
- blip compression state (BLIPFILLCSTATE) — varchar(30)
- blip src rect left (BLIPFILLSRCRECTL) — number(10)
- blip src rect top (BLIPFILLSRCRECTT) — number(10)
- blip src rect right (BLIPFILLSRCRECTR) — number(10)
- blip src rect bottom (BLIPFILLSRCRECTB) — number(10)
- blip tile tx (BLIPFILLTILETX) — number(10)
- blip tile ty (BLIPFILLTILETY) — number(10)
- blip tile sx (BLIPFILLTILESX) — number(10)
- blip tile sy (BLIPFILLTILESY) — number(10)
- blip tile flip (BLIPFILLTILEFLIP) — varchar(30)
- … +8
Outer Shadow (EFFECT_SHADOW)
- Outer Shadow id (OUTERSHDWID) — number — Primary key — NOT NULL
- Document ID (DOCUMENTID) — number — Foreign key → Effect property info.Document ID — NOT NULL
- Element ID (ELEMENTID) — number — Foreign key → Effect property info.Element ID — NOT NULL
- color id (COLORID) — number — Foreign key → Color.color id — NOT NULL
- blur radius (BLURRAD) — number(10)
- distance (DIST) — number(10)
- direction angle (DIR) — number(10)
- scale X (SCALEX) — number(6)
- scale Y (SCALEY) — number(6)
- skew X (SKEWX) — number(10)
- skew Y (SKEWY) — number(10)
- alignment (ALIGN) — varchar(20)
- rotate with shape (ROTWITHSHAPE) — boolean
Pattern Fill (PATTERNFILL)
- fill base (FILLBASEID) — number — Foreign key → FillBase.fill base — NOT NULL
- pattern preset (PRST)
- fg color (FGCOLOR) — number
- bg color (BGCOLOR) — number
Preset Color (CopyOfSRGBCOLOR)
- color id (COLORID) — number — Foreign key → Color.color id — NOT NULL
- value (COLORNAME) — varchar(6)
SCRGB Color (SCRGBCOLOR)
- color id (COLORID) — number — Foreign key → Color.color id — NOT NULL
- red (RED) — number(3)
- green (GREEN) — number(3)
- blue (BLUE) — number(3)
SRGB Color (SRGBCOLOR)
- color id (COLORID) — number — Foreign key → Color.color id — NOT NULL
- value (VAL) — varchar(6)
Scheme Color (SCHEMECOLOR)
- color id (COLORID) — number — Foreign key → Color.color id — NOT NULL
- value (COLORNAME) — varchar(50)
Solid Fill (SOLIDFILL)
- fill base (FILLBASEID) — number — Foreign key → FillBase.fill base — NOT NULL
- color id (COLORID) — number — Foreign key → Color.color id — NOT NULL
Stroke property info (STROKEINFO)
- Document ID (DOCUMENTID) — number — Foreign key → New shapeModel.Document ID — NOT NULL
- Element ID (ELEMENTID) — number — Foreign key → New shapeModel.Element ID — NOT NULL
- fill base (FILLBASEID) — number — Foreign key → FillBase.fill base — NOT NULL
- head end (HEADEND)
- tail end (TAILEND)
System Color (SYSCOLOR)
- color id (COLORID) — number — Foreign key → Color.color id — NOT NULL
- value (VAL) — number(3)
- last color (LASTCLR) — number(3)