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