inogrow

Tables (22)

adminRights

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • superVisor — int — NOT NULL
  • approvePattern — int — NOT NULL
  • approveComment — int — NOT NULL
  • moneyReturn — int — NOT NULL
  • approveCarModel — int — NOT NULL

carModels

  • id — int — Primary key — NOT NULL
  • region — varchar(128)
  • make — varchar(128)
  • model — varchar(128)
  • addedBy — int
  • approved — int

deletedUsers

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • deletedTime — timestamp — NOT NULL
  • reason — varchar(1024)
  • moneyReturnAccount — varchar(256)

favoritePatterns

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • patternId — int — Foreign key → patterns.id — NOT NULL
  • created — timestamp — NOT NULL

patternComments

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • patternId — int — Foreign key → patterns.id — NOT NULL
  • msg — varchar(600) — NOT NULL
  • created — timestamp — NOT NULL
  • approved — int — Foreign key → users.id

patternRating

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • rating — int — NOT NULL
  • patternId — int — Foreign key → patterns.id — NOT NULL

patterns

  • id — int — Primary key — NOT NULL
  • owner — int — Foreign key → users.id — NOT NULL
  • fileName — varchar(256)
  • file — longblob
  • published — tinyint — NOT NULL
  • price — decimal(10,2) — NOT NULL
  • updated — timestamp
  • popularity — int — NOT NULL
  • approved — int — Foreign key → users.id
  • tags — varchar(512) — NOT NULL
  • carModel — int — Foreign key → carModels.id

transactions

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • amount — decimal(10,2) — NOT NULL
  • description — varchar(256)
  • externalId — varchar(128)
  • created — timestamp — NOT NULL
  • method — int — Foreign key → w_transactionMethod.id
  • status — int — Foreign key → w_transactionStatus.id

users

  • id — int — Primary key — NOT NULL
  • loginMethod — varchar(45) — NOT NULL
  • email — varchar(45)
  • foreignId — varchar(45)
  • nick — varchar(30)
  • sha256pass — varchar(64)
  • jwt — varchar(64)
  • emailConfirm — varchar(64)
  • passErrors — int — NOT NULL
  • premiumTime — timestamp — NOT NULL

w_available_patterns

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • patternId — int — Foreign key → patterns.id

w_bonus

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id
  • name — varchar(128)
  • abount — int — NOT NULL
  • code — varchar(45)

w_cart

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id
  • patternId — int — Foreign key → patterns.id
  • ppfId — int — Foreign key → w_ppf.id

w_patternPlace

  • id — int — Primary key — NOT NULL
  • patternId — int — Foreign key → patterns.id — NOT NULL
  • side — varchar(128) — NOT NULL
  • place — varchar(128) — NOT NULL

w_ppf

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • name — varchar(128)
  • width — float
  • img — blob
  • price — float

w_ppfBoughtHistory

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • ppfId — int — Foreign key → w_ppf.id — NOT NULL

w_ppfCategory

  • id — int — Primary key — NOT NULL
  • ppfId — int — Foreign key → w_ppf.id — NOT NULL
  • category — varchar(45) — NOT NULL

w_ppfHIstory

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • ppfId — int — Foreign key → w_ppf.id — NOT NULL
  • time — timestamp — NOT NULL

w_sponsoredPatterns

  • id — int — Primary key — NOT NULL
  • patternId — int — Foreign key → patterns.id — NOT NULL
  • until — timestamp

w_transactionMethod

  • id — int — Primary key — NOT NULL
  • name — varchar(45) — NOT NULL

w_transactionStatus

  • id — int — Primary key — NOT NULL
  • name — varchar(45) — NOT NULL

w_userInfo

  • id — int — Primary key — NOT NULL
  • userId — int — Foreign key → users.id — NOT NULL
  • firstName — varchar(128)
  • surName — varchar(128)
  • phone — varchar(45)
  • image — blob
  • company — varchar(128)
  • adress1 — varchar(256)
  • adress2 — varchar(256)
  • w_userInfocol — varchar(45)
  • ZIP — varchar(45)
  • city — varchar(128)
  • region — varchar(45)

w_userRating

  • id — int — Primary key — NOT NULL
  • fromUser — int — Foreign key → users.id — NOT NULL
  • toUser — int — Foreign key → users.id — NOT NULL
  • rating — int — NOT NULL