Royalty

Tables (14)

bookmark

  • bookmark_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • patent_id — INTEGER — NOT NULL
  • is_bookmarked — BOOLEAN
  • created_at — TIMESTAMP

brand

  • brand_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • brand_name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • category — VARCHAR(50)
  • is_notification_enabled — BOOLEAN
  • text_vector — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

brand_analysis

  • analysis_id — INTEGER — Primary key — NOT NULL
  • brand_id — INTEGER — Foreign key → brand.brand_id — NOT NULL
  • image_score — DECIMAL
  • text_score — DECIMAL
  • risk_level — VARCHAR(50)
  • created_at — TIMESTAMP

brand_identity

  • brand_id — INTEGER — Foreign key → brand.brand_id — NOT NULL
  • logo_id — INTEGER
  • logo_features — TEXT — NOT NULL
  • identity_payload — TEXT — NOT NULL
  • last_logo_id — INTEGER
  • last_brand_name — VARCHAR(255)
  • updated_at — TIMESTAMP

brand_logo

  • logo_id — INTEGER — Primary key — NOT NULL
  • brand_id — INTEGER — Foreign key → brand.brand_id — NOT NULL
  • image_path — TEXT
  • image_vector — TEXT
  • created_at — TIMESTAMP

brand_logo_history

  • history_id — INTEGER — Primary key — NOT NULL
  • brand_id — INTEGER — Foreign key → brand.brand_id — NOT NULL
  • patent_id — INTEGER — Foreign key → patent.patent_id
  • version — INTEGER
  • image_path — TEXT — NOT NULL
  • image_similarity — DECIMAL
  • text_similarity — DECIMAL
  • ai_summary — TEXT
  • analysis_detail — TEXT
  • created_at — TIMESTAMP

detection_event

  • event_id — INTEGER — Primary key — NOT NULL
  • brand_id — INTEGER — Foreign key → brand.brand_id — NOT NULL
  • patent_id — INTEGER — Foreign key → patent.patent_id — NOT NULL
  • image_similarity — DECIMAL
  • text_similarity — DECIMAL
  • risk_level — VARCHAR(50)
  • match_type — VARCHAR(50)
  • detected_at — TIMESTAMP

fcm_token

  • fcm_token_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

notification

  • notification_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • brand_id — INTEGER — Foreign key → brand.brand_id
  • event_id — INTEGER — Foreign key → detection_event.event_id
  • message — TEXT
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

patent

  • patent_id — INTEGER — Primary key — NOT NULL
  • application_number — VARCHAR(255) — NOT NULL
  • trademark_name — VARCHAR(255) — NOT NULL
  • image_url — TEXT
  • applicant — VARCHAR(255)
  • application_date — TIMESTAMP
  • registered_date — TIMESTAMP
  • status — VARCHAR(50)
  • category — VARCHAR(50)
  • image_vector — TEXT
  • text_vector — TEXT
  • created_at — TIMESTAMP

refresh_token

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • refresh_token — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

report

  • report_id — INTEGER — Primary key — NOT NULL
  • brand_id — INTEGER — Foreign key → brand.brand_id — NOT NULL
  • file_path — TEXT
  • created_at — TIMESTAMP

trademark_expiration

  • expiration_id — INTEGER — Primary key — NOT NULL
  • patent_id — INTEGER — Foreign key → patent.patent_id — NOT NULL
  • days_left — INTEGER
  • status — VARCHAR(50)
  • last_checked_at — TIMESTAMP

users

  • user_id — INTEGER — Primary key — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • role — VARCHAR(50)
  • provider — VARCHAR(50)
  • provider_id — VARCHAR(255)
  • created_at — TIMESTAMP