A11yMarket

Tables (15)

addresses

  • address_id — RAW(16) — Primary key — NOT NULL
  • user_id — RAW(16) — Foreign key → users.user_id — NOT NULL
  • address_name — VARCHAR2(100) — NOT NULL
  • receiver_name — VARCHAR2(30) — NOT NULL
  • receiver_phone — VARCHAR2(15) — NOT NULL
  • receiver_zipcode — CHAR(5) — NOT NULL
  • receiver_addr1 — VARCHAR2(300) — NOT NULL
  • receiver_addr2 — VARCHAR2(300)
  • created_at — TIMESTAMP — NOT NULL
  • is_default — NUMBER(1,0) — NOT NULL

cart_items

  • cart_item_id — RAW(16) — Primary key — NOT NULL
  • cart_id (cart_id2) — RAW(16) — Foreign key → carts.cart_id — NOT NULL
  • product_id — RAW(16) — NOT NULL
  • quantity — INT — NOT NULL

carts

  • cart_id — RAW(16) — Primary key — NOT NULL
  • user_id — RAW(16) — Foreign key → users.user_id — NOT NULL

categories

  • category_id — RAW(16) — Primary key — NOT NULL
  • parent_cat_id — RAW(16) — Foreign key → categories.category_id
  • category_name — VARCHAR2(100) — NOT NULL

main_page_events

  • event_id — RAW(16) — Primary key — NOT NULL
  • event_title — VARCHAR2(200) — NOT NULL
  • event_description — VARCHAR2(1000) — NOT NULL
  • event_image_url — VARCHAR2(2048) — NOT NULL
  • event_url — VARCHAR2(2048)
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL

order_items

  • order_item_id — RAW(16) — Primary key — NOT NULL
  • order_id — RAW(16) — Foreign key → orders.order_id — NOT NULL
  • product_id — RAW(16) — Foreign key → products.product_id — NOT NULL
  • product_name — VARCHAR2(255) — NOT NULL
  • product_price — INT — NOT NULL
  • product_quantity — INT — NOT NULL
  • order_item_status — VARCHAR2(20) — NOT NULL
  • cancel_reason — CLOB
  • product_image_url — VARCHAR2(2048)

orders

  • order_id — RAW(16) — Primary key — NOT NULL
  • user_name — VARCHAR2(30) — NOT NULL
  • user_email — VARCHAR2(150) — NOT NULL
  • user_phone — VARCHAR2(15) — NOT NULL
  • receiver_name — VARCHAR2(30) — NOT NULL
  • receiver_phone — VARCHAR2(15) — NOT NULL
  • receiver_zipcode — CHAR(5) — NOT NULL
  • receiver_addr1 — VARCHAR2(300) — NOT NULL
  • receiver_addr2 — VARCHAR2(300)
  • total_price — INT — NOT NULL
  • order_status — VARCHAR2(30) — NOT NULL
  • created_at — TIMESTAMP
  • payment_key — VARCHAR2(200)

product_ai_summary

  • product_id — RAW(16) — Foreign key → products.product_id — NOT NULL
  • seller_id — Foreign key → products.seller_id — NOT NULL
  • category_id — RAW(16) — Foreign key → products.category_id — NOT NULL
  • summary_text — CLOB
  • usage_context — CLOB
  • usage_method — CLOB
  • generated_at — TIMESTAMP

product_images

  • image_id — RAW(16) — Primary key — NOT NULL
  • product_id — RAW(16) — Foreign key → products.product_id — NOT NULL
  • seller_id — Foreign key → products.seller_id — NOT NULL
  • category_id — RAW(16) — Foreign key → products.category_id — NOT NULL
  • image_url — VARCHAR2(2048) — NOT NULL
  • alt_text — CLOB
  • created_at — TIMESTAMP
  • image_sequence — INT — NOT NULL

products

  • product_id — RAW(16) — Primary key — NOT NULL
  • seller_id — RAW(16) — Foreign key → sellers.seller_id — NOT NULL
  • category_id — RAW(16) — Foreign key → categories.category_id — NOT NULL
  • product_price — INT — NOT NULL
  • product_stock — INT — NOT NULL
  • product_name — VARCHAR2(256) — NOT NULL
  • product_description — CLOB — NOT NULL
  • product_ai_summary — CLOB
  • product_status — VARCHAR2(20) — NOT NULL
  • submit_date — TIMESTAMP — NOT NULL
  • approved_date — TIMESTAMP
  • updated_at — TIMESTAMP — NOT NULL

refresh_token

  • refresh_token_id — RAW(16) — Primary key — NOT NULL
  • user_id — RAW(16) — Foreign key → users.user_id — NOT NULL
  • token — VARCHAR2(512) — NOT NULL
  • expiry_date — TIMESTAMP — NOT NULL

sellers

  • seller_id — RAW(16) — Primary key — NOT NULL
  • user_id — RAW(16) — Foreign key → users.user_id — NOT NULL
  • seller_name — VARCHAR2(255) — NOT NULL
  • business_number — VARCHAR2(50) — NOT NULL
  • seller_grade — VARCHAR2(30) — NOT NULL
  • seller_intro — VARCHAR2(1024)
  • is_a11y_guarantee — NUMBER(1) — NOT NULL
  • seller_submit_status — VARCHAR2(20) — NOT NULL
  • submit_date — TIMESTAMP — NOT NULL
  • approved_date — TIMESTAMP
  • updated_at — TIMESTAMP — NOT NULL

user_a11y_profiles

  • profile_id — RAW(16) — Primary key — NOT NULL
  • user_id — RAW(16) — Foreign key → users.user_id — NOT NULL
  • profile_name — VARCHAR2(50) — NOT NULL
  • description — VARCHAR2(200)
  • is_preset — NUMBER(1,0) — NOT NULL
  • contrast_level — NUMBER(1,0) — NOT NULL
  • text_size_level — NUMBER(1,0) — NOT NULL
  • text_spacing_level — NUMBER(1,0) — NOT NULL
  • line_height_level — NUMBER(1,0) — NOT NULL
  • text_align — VARCHAR2(10) — NOT NULL
  • screen_reader — NUMBER(1,0) — NOT NULL
  • smart_contrast — NUMBER(1,0) — NOT NULL
  • highlight_links — NUMBER(1,0) — NOT NULL
  • cursor_highlight — NUMBER(1,0) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_oauth_links

  • user_oauth_link_id — RAW(16) — Primary key — NOT NULL
  • user_id — RAW(16) — Foreign key → users.user_id — NOT NULL
  • oauth_provider — VARCHAR2(50) — NOT NULL
  • oauth_provider_id — VARCHAR2(255) — NOT NULL
  • created_at — TIMESTAMP

users

  • user_id — RAW(16) — Primary key — NOT NULL
  • user_name — VARCHAR2(30) — NOT NULL
  • user_pass — VARCHAR2(60)
  • user_email — VARCHAR2(254)
  • user_phone — VARCHAR2(15)
  • user_nickname — VARCHAR2(100)
  • user_role — VARCHAR2(30) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP