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