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)