IMPORT
Tables (20)
admins
- admin_id — VARCHAR2(20)
- password — VARCHAR2(100) — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- ad_email — VARCHAR2(50)
- created_at — DATE
- is_active — NUMBER(1)
bank_accounts
- account_id — NUMBER
- bank_name — VARCHAR2(50) — NOT NULL
- account_number — VARCHAR2(50) — NOT NULL
- account_holder — VARCHAR2(50) — NOT NULL
- is_active — NUMBER(1)
brands
- brand_id — NUMBER
- name — VARCHAR2(50) — NOT NULL
carts
- cart_id — NUMBER
- user_id — VARCHAR2(20)
- session_id — VARCHAR2(100)
- created_at — DATE
categories
- category_id — NUMBER
- name — VARCHAR2(50) — NOT NULL
chatbot_logs
- log_id — NUMBER
- user_id — VARCHAR2(20)
- question — CLOB
- answer — CLOB
- category — VARCHAR2(50)
- status — VARCHAR2(20)
- is_escalated — NUMBER(1)
- asked_at — DATE
email_verifications
- verification_id — NUMBER
- user_id — VARCHAR2(20)
- email — VARCHAR2(50)
- token — VARCHAR2(100)
- is_verified — NUMBER(1)
- requested_at — DATE
- expires_at — DATE
login_attempts
- attempt_id — NUMBER
- user_id — VARCHAR2(20)
- attempt_time — DATE
- success — NUMBER(1)
- ip_address — VARCHAR2(45)
password_resets
- reset_id — NUMBER
- user_id — VARCHAR2(20)
- email — VARCHAR2(50)
- verified — NUMBER(1)
- requested_at — DATE
payment_methods
- method_id — NUMBER
- name — VARCHAR2(50) — NOT NULL
- provider — VARCHAR2(50) — NOT NULL
- active — NUMBER(1) — NOT NULL
phone_verifications
- verification_id — NUMBER
- user_id — VARCHAR2(20)
- phone — VARCHAR2(20)
- code — VARCHAR2(10)
- is_verified — NUMBER(1)
- requested_at — DATE
- expires_at — DATE
point_history
- point_id — NUMBER
- user_id — VARCHAR2(20)
- change_type — VARCHAR2(20)
- amount — NUMBER
- description — VARCHAR2(200)
- created_at — DATE
- expiration_date — DATE
seller_applications
- application_id — NUMBER
- user_id — VARCHAR2(20)
- business_name — VARCHAR2(100)
- business_number — VARCHAR2(20)
- application_date — DATE
- status — VARCHAR2(20)
social_users
- social_id — VARCHAR2(100)
- user_id — VARCHAR2(20)
- provider — VARCHAR2(20)
- linked_at — DATE
styles
- style_id — NUMBER
- name — VARCHAR2(50) — NOT NULL
- description — VARCHAR2(200)
- is_active — NUMBER(1)
tags
- tag_id — NUMBER
- name — VARCHAR2(50) — NOT NULL
user_addresses
- address_id — NUMBER
- user_id — VARCHAR2(20) — NOT NULL
- alias — VARCHAR2(50) — NOT NULL
- recipient_name — VARCHAR2(50) — NOT NULL
- phone — VARCHAR2(20) — NOT NULL
- zipcode — VARCHAR2(10) — NOT NULL
- address_line1 — VARCHAR2(100) — NOT NULL
- address_line2 — VARCHAR2(100) — NOT NULL
- is_default — NUMBER(1)
- created_at — DATE
user_styles
- user_style_id — NUMBER
- user_id — VARCHAR2(20)
- session_id — VARCHAR2(100)
- style_id — NUMBER
- preference — NUMBER(1)
- updated_at — DATE
users
- user_id — VARCHAR2(20)
- password — VARCHAR2(100) — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- email — VARCHAR2(50)
- phone — VARCHAR2(20)
- user_tel — VARCHAR(20)
- created_at — DATE
- gender — CHAR(1)
- user_email — VARCHAR2(30) — NOT NULL
- user_grade — VARCHAR2(30)
- user_point — NUMBER
- nickname — VARCHAR2(30)
- is_active — NUMBER(1)
- is_verified_email — NUMBER(1)
- is_verified_phone — NUMBER(1)
- default_address_id — NUMBER
wishlists
- wishlist_id — NUMBER
- user_id — VARCHAR2(20)
- product_id — NUMBER
- created_at — DATE