inogrow

Tables (39)

admin

  • Key (admin_id) — long — Primary key — NOT NULL
  • Key (identifier) — varchar — Foreign key → role.Key — NOT NULL — user email or admin identifier
  • Field (password) — varchar
  • Field (recent_login) — date
  • Field2 (created_date) — date
  • Field3 (updated_date) — date
  • Field4 (is_enable) — enum(y,n)

banner

  • Key (banner_id) — long — Primary key — NOT NULL
  • Field (title) — varchar
  • Field2 (state) — varchar
  • Field3 (type) — varchar
  • (image) — varchar
  • Field2 (created_date) — date
  • Field (updated_date) — date

basket

  • Key (basket_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Key (product_id) — long — Foreign key → product.Key — NOT NULL
  • Key (product_option_id) — long — Foreign key → product_option.Key — NOT NULL
  • Field (count) — int

bonus

  • Key (bonus_id) — long — Primary key — NOT NULL
  • Field (key) — varchar
  • Field2 (add_bonus_credit) — float
  • Field (is_use) — enum(y,n)
  • Field (period_date) — date

bookmark

  • Key (bookmark_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Key (upload_pattern_id) — long — Foreign key → upload_pattern.Key — NOT NULL

category

  • Key (category_id) — long — Primary key — NOT NULL
  • Field (title) — varchar
  • Field2 (parent_id) — long
  • Field3 (content) — varchar
  • Field4 (seq) — int
  • Field5 (type) — varchar

comment

  • Key (comment_id) — long — Primary key — NOT NULL
  • Key (review_id) — long — Foreign key → review.Key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Field (content) — varchar
  • Field2 (created_date) — date
  • (is_enable) — enum(y,n)

coupon

  • Key (coupon_id) — long — Primary key — NOT NULL
  • Field (coupon_type) — varchar
  • Field2 (period_type) — varchar
  • Field3 (coupon_title) — varchar
  • Field4 (description) — varchar
  • Field5 (period_date) — date
  • Field6 (benefit_type) — varchar
  • Field7 (type) — varchar
  • Field8 (min_price) — float
  • Field9 (buy_price) — float

credit

  • Key (credit_id) — long — Primary key — NOT NULL
  • Field (title) — varchar
  • Field2 (price) — float
  • Field (add_credit) — float
  • Field (bonus_credit) — float

credit_payment

  • Key (payments_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Key (merchant_uid) — long — Foreign key → merchant.Key — NOT NULL
  • Key (product_option_id) — long — Foreign key → merchant.Key — NOT NULL
  • Key (method) — varchar — NOT NULL
  • Field (description) — varchar
  • Field4 (paypal_amount) — float
  • Field (amount) — float
  • Field (state) — varchar
  • Field (created_at) — date

delivery_fee

  • Key (delivery_fee_id) — long — Primary key — NOT NULL
  • Field (category_id) — long — area
  • Field2 (weight) — float
  • Field3 (price) — float

editor

  • Key (editor_id) — long — Primary key — NOT NULL
  • id (user_id) — long — Foreign key → user.user_id — NOT NULL
  • Field2 (created_date) — date
  • Field2 (end_date) — date
  • Field3 (payment_due_date) — date
  • Field (cancel_date) — date

editor_pattern

  • Key (editor_pattern_id) — long — Primary key — NOT NULL
  • Key (upload_pattern_id) — long — Foreign key → upload_pattern.Key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Field (area) — varchar
  • Field2 (file) — varchar
  • Field3 (thumbnail) — varchar
  • Field4 (fare) — float
  • Field5 (save_date) — date
  • Field7 (created_date) — date
  • Field (updated_date) — date
  • Field (is_enable) — enum(y,n)

email_auto_send

  • Key (email_auto_send_id) — long — Primary key — NOT NULL
  • Field (title) — varchar
  • Field2 (content) — varchar
  • Field3 (state) — varchar
  • Field (created_date) — date
  • Field2 (updated_date) — date

grade

  • Key (grade_id) — long — Primary key — NOT NULL
  • Field (title) — varchar
  • Field2 (condition) — varchar
  • Field (fee) — float

history

  • Key (history_id) — long — Primary key — NOT NULL
  • Key (editor_pattern_id) — long — Foreign key → editor_pattern.Key — NOT NULL
  • Field (ploting_amount) — float

merchant

  • Key (merchant_id) — long — Primary key — NOT NULL
  • Key (type) — varchar — Primary key — NOT NULL
  • Key2 (type_id) — long — Primary key — NOT NULL
  • Key (merchant_uid) — varchar — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Key (product_option_id) — long — Foreign key → product_option.Key — NOT NULL
  • Field (count) — int
  • Field2 (state) — varchar
  • Field (amount) — float
  • Field (created_date) — date
  • Field (updated_date) — date
  • Field (is_enable) — enum(y,n)

pattern_rating

  • Key (pattern_rating_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Key (upload_pattern_id) — long — Foreign key → upload_pattern.Key — NOT NULL
  • Field (type) — varchar
  • Field2 (rating) — int
  • Field4 (created_date) — date

payment(transaction) (payment)

  • Key (payments_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Key (merchant_uid) — varchar — Foreign key → merchant.Key — NOT NULL
  • Key (product_option_id) — long — Foreign key → merchant.Key — NOT NULL
  • Key (user_coupon_id) — long — Foreign key → user_coupon.Key — NOT NULL
  • Key (method) — varchar — NOT NULL
  • Field (description) — varchar
  • Field (price) — float
  • Field (amount) — float
  • Field (discount_price) — float
  • Field (state) — varchar
  • Field2 (profit) — float
  • Field (creadit) — float
  • Field4 (paypal_amount) — float
  • Field (created_date) — date

product

  • Key (product_id) — long — Primary key — NOT NULL
  • Field (thumbnail) — varchar
  • Field2 (title) — varchar
  • Field3 (dept1) — long — category_id
  • Field4 (dept2) — long — category_id
  • (dept3) — long — category_id
  • Field (price) — float
  • Field (stock) — int

product_option

  • Key (product_option_id) — long — Primary key — NOT NULL
  • Key (product_id) — long — Foreign key → product.Key — NOT NULL
  • Field (option) — varchar
  • (price) — float
  • Field (weghit) — float
  • Field (stock) — varchar

product_rates

  • Key (product_rates_id) — long — Primary key — NOT NULL
  • Key (product_id) — long — Foreign key → product.Key — NOT NULL
  • Field (count) — int
  • Field2 (discount_price) — float
  • Field3 (value) — varchar
  • Field4 (created_date) — date
  • Field (updated_date) — date

project

  • Key (project_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Field (created_date) — date
  • Field (is_enable) — enum(y,n)

project_pattern

  • Key (project_pattern_id) — long — Primary key — NOT NULL
  • Key (project_id) — long — Foreign key → project.Key — NOT NULL
  • Key (editor_pattern_id) — long — Foreign key → editor_pattern.Key — NOT NULL
  • Field (created_date) — date
  • Field2 (is_enable) — enum(y,n)

refund

  • Key (refund_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Key (payments_id) — long — Foreign key → payment(transaction).Key — NOT NULL
  • Field (state) — varchar
  • Field2 (created_date) — date

retention

  • Key (retention_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Field (credit) — float
  • Field2 (bonus_credit) — float
  • Field3 (profit) — float

review

  • Key (review_id) — long — Primary key — NOT NULL
  • Key (upload_pattern_id) — long — Foreign key → upload_pattern.Key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Field (content) — varchar
  • (created_date) — date
  • Field (is_enable) — enum(y,n)

role

  • id (role_id) — long — Primary key — NOT NULL
  • Key (identifier) — varchar — Primary key — NOT NULL — user email or admin identifier
  • Field3 (role) — varchar

setting

  • Key (setting_id) — long — Primary key — NOT NULL
  • Field (variable) — varchar
  • Field2 (contents) — varchar
  • Field (created_date) — date
  • Field2 (updated_date) — date

shipping

  • Key (shipping_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Key (merchant_id) — long — Foreign key → merchant.Key — NOT NULL
  • Key (product_option_id) — long — Foreign key → merchant.Key — NOT NULL
  • Field (state) — varchar
  • Field2 (info) — varchar
  • Field3 (created_date) — date
  • Field (count) — int
  • Field (cancel_date) — date
  • Field (region) — varchar
  • Field2 (address) — varchar
  • Field3 (detail_address) — varchar
  • Field4 (postal_code) — varchar
  • Field5 (city) — varchar
  • Field6 (continent) — varchar
  • Field (vay_tax_id) — varchar

sponsor

  • Key (sponsor_id) — long — Primary key — NOT NULL
  • Key (upload_pattern_id) — long — Foreign key → upload_pattern.Key — NOT NULL
  • Key (payments_id) — long — Foreign key → payment(transaction).Key — NOT NULL
  • Field (start_date) — date
  • Field2 (end_date) — date

unit_price

  • Key (unit_price_id) — long — Primary key — NOT NULL
  • Field (seq) — int
  • Field2 (contents) — varchar
  • Field (type) — varchar
  • Field (unit) — int
  • Field (created_date) — date
  • Field2 (updated_date) — date

upload_pattern

  • Key (upload_pattern_id) — long — Primary key — NOT NULL
  • Key (uploader_id) — long — Foreign key → uploader.Key — NOT NULL
  • Field (file) — varchar
  • Field2 (state) — varchar
  • Field3 (description) — varchar
  • Field4 (reason) — varchar
  • Field5 (download_count) — int
  • Field6 (area) — float
  • Field9 (unit_price) — float
  • Field10 (is_new)
  • Field11 (thumbnail) — varchar
  • Field12 (region_id) — long
  • Field14 (year_id) — long
  • Field13 (brand_id) — long
  • Field15 (model_id) — long
  • Field16 (sub_model_id) — long
  • Field17 (series_id) — long
  • Field18 (part_section_id) — long
  • Field19 (pattern_part_id) — long
  • Field (sub_part_id) — long
  • Field2 (tag1) — varchar
  • Field3 (tag2) — varchar
  • Field4 (tag3) — varchar
  • Field5 (tag4) — varchar
  • Field6 (tag5) — varchar
  • Field7 (created_date) — date
  • Field8 (updated_date) — date
  • Field (is_enable) — enum(y,n)

uploader

  • Key (uploader_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Field (introduction) — varchar
  • Field2 (state) — varchar
  • Field3 (image) — varchar
  • Field (sponser)

user

  • user_id — long — Primary key — NOT NULL
  • Key (grade_id) — long — Foreign key → grade.Key — NOT NULL
  • Key (email) — varchar — Foreign key → role.Key — NOT NULL
  • Field2 (password) — varchar
  • Field3 (first_name) — varchar
  • Field4 (second_name) — varchar
  • Field5 (nick_name) — varchar
  • Field6 (tel) — varchar
  • Field7 (region) — varchar
  • Field8 (address) — varchar
  • Field9 (detail_address) — varchar
  • Field10 (postal_code) — varchar
  • Field11 (city) — varchar
  • Field (continent) — varchar
  • Field2 (company) — varchar
  • Field5 (state) — varchar
  • Field6 (image) — varchar
  • Field (leave_date) — date
  • Field4 (created_date) — date
  • Field2 (update_date) — date
  • Field (is_enable) — enum(y,n)

user_coupon

  • Key (user_coupon_id) — long — Primary key — NOT NULL
  • Key (coupon_id) — long — Foreign key → coupon.Key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Field (state) — varchar
  • Field2 (created_date) — date
  • Field3 (use_date) — date

user_log

  • Key (user_use_log_id) — long — Primary key — NOT NULL
  • id (user_id) — long — Foreign key → user.user_id — NOT NULL
  • Field (type) — varchar — +,-
  • Field2 (type2) — varchar — product,editor,pattern.....
  • Field3 (unit) — varchar — profit,usd,credit,bonus_credit
  • Field4 (usage) — float
  • Field5 (created_date) — date

user_review

  • Key (user_review_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Field (type) — varchar
  • Field2 (type_id) — long
  • (check) — enum(y,n)

withdrawal

  • Key (withdrawal_id) — long — Primary key — NOT NULL
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • Field (created_date) — date — request date
  • Field2 (method) — varchar
  • Field3 (amount) — float
  • Field4 (fee) — float
  • Field5 (paypal_email) — varchar
  • Field6 (state) — varchar
  • Field7 (withdrawal_approval_date) — date
  • Field8 (withdrawal_complete_date) — date