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