SeobukShopingMall

Tables (20)

Untitled (tbl_questions)

  • Key (question_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (created_date) — DATETIME — NOT NULL
  • Field (quest_content) — TEXT — NOT NULL
  • Field (reply_content) — TEXT
  • Field (status) — INT
  • Field (update_date) — DATETIME
  • Field (type_question) — INT — NOT NULL
  • Key (answered_by) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (tbl_delivery_address_defaults)

  • Key (delivery_address_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (delivery_address) — VARCHAR(255) — NOT NULL
  • Field2 (receiver) — VARCHAR(255) — NOT NULL
  • Field3 (phone_number) — VARCHAR(20) — NOT NULL
  • Field4 (number_of_mailbox) — VARCHAR(255) — NOT NULL
  • Field5 (address1) — VARCHAR(255) — NOT NULL
  • Field6 (address2) — VARCHAR(255)
  • Field (other_request) — VARCHAR(255)
  • Field2 (accumulated_points) — INT
  • Field3 (method_payment) — INT — NOT NULL
  • Field (is_default) — BIT(1)

Untitled (tbl_descriptions_products)

  • Key (descriptions_product_id) — BIGINT — Primary key — NOT NULL
  • Key (product_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — LONGTEXT — NOT NULL
  • Field2 (title) — VARCHAR(255) — NOT NULL
  • Field3 (path) — VARCHAR(255)

Untitled (tbl_paid_orders)

  • Key (paid_orders_id) — BIGINT — Primary key — NOT NULL
  • Key (order_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field5 (order_date) — DATETIME — NOT NULL
  • Field6 (total_amount) — DOUBLE — NOT NULL
  • Field7 (total_quantity) — INT — NOT NULL

Untitled (tbl_posts_files)

  • Key (post_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (file_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — INT — NOT NULL

Untitled (tbl_posts)

  • Key (post_id) — BIGINT — Primary key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field5 (title) — VARCHAR(255) — NOT NULL
  • Field6 (post_content) — LONGTEXT — NOT NULL

Untitled (tbl_products_files)

  • Key (product_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (file_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (tbl_question_files)

  • Key (file_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (question_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — INT — NOT NULL

Untitled (tbl_refresh_tokens)

  • Key (refresh_token_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (role_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field (expiry_date) — DATETIME
  • Field2 (token) — VARCHAR(255)

Untitled (tbl_customer_relationships)

  • Key (customer_relationships_id) — BIGINT — Primary key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field (total_spent) — DOUBLE
  • Field (level) — INT
  • Field (accumulated_points) — DOUBLE
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (tbl_banners)

  • Key (banner_id) — BIGINT — Primary key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field (create_date) — DATETIME
  • Field3 (modifier_date) — DATETIME
  • Field2 (modifier_by) — VARCHAR(255)
  • Field (display_order) — INT — NOT NULL
  • Field2 (end_date) — DATETIME
  • Field (path_desktop) — VARCHAR(255) — NOT NULL
  • Field3 (path_mobile) — VARCHAR(255) — NOT NULL
  • Field (start_date) — DATETIME
  • Field (status) — BIT(1) — NOT NULL

Untitled (tbl_products_hashtags)

  • Key (hashtag_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (tbl_products)

  • Key (product_id) — BIGINT — Primary key — NOT NULL
  • Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field (regular_price) — DOUBLE — NOT NULL
  • Field2 (purchase_price) — DOUBLE
  • Field3 (name) — VARCHAR(255) — NOT NULL
  • Field4 (discount) — DOUBLE
  • Field5 (thumbnail) — VARCHAR(255) — NOT NULL
  • Field (stock_quantity) — INT
  • Field (options) — TEXT
  • Field (is_delete) — BIT(1)
  • Field (specifications) — TEXT — NOT NULL
  • Field (shipping_fee) — DOUBLE
  • Field2 (shipping_conditions) — DOUBLE

Untitled (tbl_order_detail)

  • Key (order_detail_id) — BIGINT — Primary key — NOT NULL
  • Key (order_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (product_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field (price) — DOUBLE — NOT NULL
  • Field (quantity) — INT — NOT NULL
  • Field (status) — INT
  • Field (code) — VARCHAR(255) — NOT NULL
  • Field2 (options) — VARCHAR(255)

Untitled (tbl_orders)

  • Key (order_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field (status) — INT — NOT NULL
  • Field (total_amount) — DOUBLE — NOT NULL
  • Field (total_quantity) — INT — NOT NULL
  • Field (delivery_address) — VARCHAR(255) — NOT NULL
  • Field2 (receiver) — VARCHAR(255) — NOT NULL
  • Field3 (phone_number) — VARCHAR(20) — NOT NULL
  • Field4 (number_of_mailbox) — VARCHAR(255) — NOT NULL
  • Field (address1) — VARCHAR(255) — NOT NULL
  • Field2 (address2) — VARCHAR(255)
  • Field3 (other_request) — VARCHAR(255)
  • Field (accumulated_points) — INT
  • Field2 (method_payment) — INT — NOT NULL — 1: Credit; 2: Transfer; 3: virtual account

Untitled (tbl_roles)

  • Key (role_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL — ROLE_SUPER_ADMIN, ROLE_ADMIN, ROLE_USER

Untitled (tbl_users)

  • Key (user_id) — BIGINT — Primary key — NOT NULL
  • Key (role_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field (active) — BIT(1)
  • Field (address1) — VARCHAR(255) — NOT NULL
  • Field (address2) — VARCHAR(255)
  • Field (age) — INT — NOT NULL
  • Field (birth_date) — DATE — NOT NULL
  • Field (gender) — INT — NOT NULL
  • Field (name) — VARCHAR(255) — NOT NULL
  • Field (is_delete) — BIT(1)
  • Field (nick_name) — VARCHAR(255) — NOT NULL
  • Field (password) — VARCHAR(255) — NOT NULL
  • Field (phone_number) — VARCHAR(20) — NOT NULL
  • Field (username) — VARCHAR(255) — NOT NULL
  • Field (thumbnail) — VARCHAR(255) — NOT NULL
  • Field (sms_code) — VARCHAR(6)

Untitled (tbl_hashtags)

  • Key (hashtag_id) — BIGINT — Primary key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field (name) — VARCHAR(255) — NOT NULL

Untitled (tbl_files)

  • Key (file_id) — BIGINT — Primary key — NOT NULL
  • Field (create_by) — VARCHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VARCHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field (path) — VARCHAR(255) — NOT NULL

Untitled (tbl_categories)

  • Key (category_id) — BIGINT — Primary key — NOT NULL
  • Field (create_by) — VACHAR(255)
  • Field2 (create_date) — DATETIME
  • Field3 (modifier_by) — VACHAR(255)
  • Field4 (modifier_date) — DATETIME
  • Field (display_order) — INT — NOT NULL
  • Field (icon) — VACHAR(255)