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)