second-handler
Tables (13)
crawl_credentials
- credential_id — INT
- crawl_source_id — INT
- username — VARCHAR(100) — NOT NULL
- encrypted_password — VARCHAR(255) — NOT NULL
- additional_info — TEXT
- last_updated — DATETIME
crawl_sources
- crawl_source_id — INT
- source_name — VARCHAR(100) — NOT NULL
- source_url — VARCHAR(255) — NOT NULL
- last_crawled — DATETIME
- crawl_frequency — VARCHAR(50)
favorites
- favorite_id — INT
- user_id — INT
- item_id — INT
- added_date — DATETIME
images
- image_id — INT
- item_id — INT
- image_url — VARCHAR(255) — NOT NULL
- upload_date — DATETIME
item_tags
- item_tag_id — INT
- item_id — INT
- tag_id — INT
items
- item_id — INT
- seller_id — INT
- crawl_source_id — INT
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- category — ENUM( 'Electronics', 'Clothing', 'Home_and_Garden', 'Sports', 'Toys', 'Books', 'Vehicles', 'Jewelry', 'Beauty', 'Pet_Supplies', 'Office_Supplies', 'Music_Instruments', 'Art', 'Collectibles', 'Food_and_Beverages', 'Health', 'Other' ) — NOT NULL
- item_condition — ENUM( 'New', 'Like_New', 'Very_Good', 'Good', 'Acceptable', 'For_Parts_or_Not_Working' ) — NOT NULL
- location — VARCHAR(100)
- post_date — DATETIME
- status — ENUM('Available', 'Sold', 'Reserved')
- external_id — VARCHAR(100)
- search_attributes — TEXT
- specifications — TEXT
messages
- message_id — INT
- sender_id — INT
- receiver_id — INT
- item_id — INT
- content — TEXT
- sent_date — DATETIME
- is_read — BOOLEAN
oauth_access_tokens
- id — BIGINT
- user_id — BIGINT — NOT NULL
- client_id — BIGINT — NOT NULL
- access_token — VARCHAR(255) — NOT NULL
- refresh_token — VARCHAR(255)
- scope — TEXT
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_access_token
- INDEX — idx_refresh_token
- INDEX — idx_user_client_token
oauth_accounts
- id — BIGINT
- user_id — BIGINT — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- access_token — TEXT — NOT NULL
- refresh_token — TEXT
- email — VARCHAR(255)
- name — VARCHAR(255)
- profile_image_url — TEXT
- expires_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_user_id
oauth_clients
- id — BIGINT
- client_id — VARCHAR(100) — NOT NULL
- client_secret — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- redirect_uri — TEXT — NOT NULL
- allowed_scopes — TEXT
- is_confidential — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_client_id
tags
- tag_id — INT
- tag_name — VARCHAR(50) — NOT NULL
- tag_type — VARCHAR(50)
user_category_preferences
- preference_id — INT
- user_id — INT
- category — ENUM( 'Electronics', 'Clothing', 'Home_and_Garden', 'Sports', 'Toys', 'Books', 'Vehicles', 'Jewelry', 'Beauty', 'Pet_Supplies', 'Office_Supplies', 'Music_Instruments', 'Art', 'Collectibles', 'Food_and_Beverages', 'Health', 'Other' ) — NOT NULL
- preference_level — INT
- last_updated — DATETIME
users
- id — BIGINT
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- profile_image_url — TEXT
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_email
- INDEX — idx_username