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