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