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