ERD
Tables (25)
Orders (orders)
- id — int — Primary key — NOT NULL
- created — timestamp
- shippingInfo — varchar(128)
- payment — varchar(45)
- totalPrice — decimal(10,2)
- DCPrice — decimal(10,2)
- coupon — decimal(10,2)
- profit — decimal(10,2)
- credit — decimal(10,2)
- amounts — decimal(10,2)
- contry — varchar(128)
- adress1 — varchar(256)
- adress2 — varchar(256)
- ZipPostal — varchar(45)
- townCity — varchar(45)
- region — varchar(45)
- vatTaxId — varchar(45)
- shippingURL — varchar(2084)
- status — varchar(45)
- userId — int — Foreign key → User.ID — NOT NULL
- product1 — int
- product2 — int
- product3 — int
- product4 — int
- product5 — int
User (Untitled)
- ID (id) — int — Primary key — NOT NULL
- Status of user (Status) — varchar(45)
- Level of user (level) — varchar(45)
- merchant — varchar(45)
- productName — varchar(45)
- loginMethod — varchar(45)
- email — varchar(45)
- nick — varchar(30)
- sha256pass — varchar(64)
- jwt — varchar(64)
- emailConfirm — varchar(64)
- passErrors — int
- country — varchar(45)
- created — timestamp
- firstName — varchar(45)
- surName — varchar(45)
- adress1 — varchar(256)
- adress2 — varchar(256)
- postalCode — varchar(45)
- city — varchar(45)
- stateRegion — varchar(45)
- compantName — varchar(45)
- id (foreignId) — varchar(45) — Foreign key → emails.id — NOT NULL
adminRights (4)
- id — int — Primary key — NOT NULL
- superVisor — int
- approvePattern — int
- approveComment — int
- moneyReturn — int
- approveCarModel — int
- ID (userId) — int — Foreign key → User.ID — NOT NULL
banners
- id — int — Primary key — NOT NULL
- file — longblob
- name — varchar(256)
- status — varchar(45)
- category — varchar(45)
- type — varchar(45)
- dateStart — timestamp
- dateEnd — timestamp
- linkAdded — varchar(2083)
- linkTarget — varchar(2083)
carModels
- id — int — Primary key — NOT NULL
- region — varchar(128)
- make — varchar(128)
- year — varchar(45)
- model — varchar(128)
- subModel — varchar(128)
- series — varchar(128)
- ID (approved) — int — Foreign key → User.ID — NOT NULL
- ID (addedBy) — int — Foreign key → User.ID — NOT NULL
carPlaces
- id — int — Primary key — NOT NULL
- side — varchar(128)
- part — varchar(128)
- subPart — varchar(128)
couponIssue
- id — int — Primary key — NOT NULL
- issueMethod — varchar(128)
- couponId — int — Foreign key → coupons.id — NOT NULL
- userId — int — Foreign key → User.ID — NOT NULL
coupons
- id — int — Primary key — NOT NULL
- name — varchar(256)
- benifitType — varchar(128)
- benifitAmount (benifitAmountbenifitAmount) — int
- benefitUnit — varchar(16)
- startUse — timestamp
- endUse — timestamp
- issuanceClassification — varchar(128)
- issuanceMethod — varchar(128)
- status — varchar(45)
- issuanceStatus — varchar(45)
- area — varchar(128)
- minimumIssued — decimal(10,2)
- minimumPurchase — decimal(10,2)
- ID (dept1CategoryId) — int — Foreign key → ultrafitCategory.ID — NOT NULL
- ID (dept2CategoryId) — int — Foreign key → ultrafitCategory.ID — NOT NULL
- ID (dept3CategoryId) — int — Foreign key → ultrafitCategory.ID — NOT NULL
creditProducts
- id — int — Primary key — NOT NULL
- name — varchar(45)
- cost — decimal(10,2)
- recharge — decimal(10,2)
- bonus — decimal(10,2)
deletedUsers
- id — int — Primary key — NOT NULL
- deletedTime — timestamp
- reason — varchar(1024)
- moneyReturnAccount — varchar(256)
- userId — int — Foreign key → User.ID — NOT NULL
emails
- id — int — Primary key — NOT NULL
- name — varchar(512)
- content — varchar(5000)
- status — varchar(45)
- detailType — tinyint
- signUp — tinyint
- dormantAccount — tinyint
- stopAccount — tinyint
- shippingInfo — tinyint
favoritePatterns
- id — int — Primary key — NOT NULL
- created — timestamp
- userId — int — Foreign key → User.ID — NOT NULL
- patternId — int — Foreign key → patterns.id — NOT NULL
floatVariables
- id — int — Primary key — NOT NULL
- name — varchar(128)
- value — decimal(10,2)
patternComments
- id — int — Primary key — NOT NULL
- created — timestamp
- Id (userId) — int — Foreign key → User.ID — NOT NULL
- patternId — int — Foreign key → patterns.id — NOT NULL
- msg — varchar(600)
- Id (approved) — int — Foreign key → User.ID — NOT NULL
patternRating
- id — int — Primary key — NOT NULL
- rating — int
- patternId — int — Foreign key → patterns.id — NOT NULL
- userId — int — Foreign key → User.ID — NOT NULL
patterns
- id — int — Primary key — NOT NULL
- svg — longblob
- plt — longblob
- published — tinyint
- price — decimal(10,2)
- earningSum — decimal(10,2)
- updated — timestamp
- popularity — int
- downloads — int
- tags — varchar(512)
- size — int
- status — varchar(45)
- carModel — int — Foreign key → carModels.id — NOT NULL
- id (carPlace) — int — Foreign key → carPlaces.id — NOT NULL
- approved — int
- owner — int
policy
- id — int — Primary key — NOT NULL
- country — varchar(45)
- policy — text
shippingAreaRegion
- id — int — Primary key — NOT NULL
- area — int
- region — varchar(128)
shippingAreaWeight
- id — int — Primary key — NOT NULL
- area — int
- weight — decimal(10,2)
- sum — decimal(10,2)
sponsorAd
- id — int — Primary key — NOT NULL
- profit — decimal(10,2)
- credit — decimal(10,2)
- paypal — decimal(10,2)
- start — timestamp
- end — timestamp
- id (patId) — int — Foreign key → patterns.id — NOT NULL
suspendedUsers
- id — int — Primary key — NOT NULL
- suspendedTime — timestamp
- ID (userId) — int — Foreign key → User.ID — NOT NULL
transactions
- id — int — Primary key — NOT NULL
- amount — decimal(10,2)
- netAmount — decimal(10,2)
- description — varchar(256)
- externalId — varchar(128)
- created — timestamp
- method — int
- status — varchar(128)
- ppEmail — varchar(256)
- ID (userId) — int — Foreign key → User.ID — NOT NULL
ultrafit
- id — int — Primary key — NOT NULL
- file — longblob
- name — varchar(128)
- inventory — int
- exposure — tinyint
- price — decimal(9,2)
- description — varchar(2000)
- ID (categoryId) — int — Foreign key → ultrafitCategory.ID — NOT NULL
ultrafitCategory (Untitled2)
- ID (id) — int — Primary key — NOT NULL
- dept — varchar(45)
- name — varchar(128)
userPhoto (Untitled3)
- id — int — Primary key — NOT NULL
- photo — longblob
- ID (userId) — int — Foreign key → User.ID — NOT NULL