brand

Tables (3)

brand (Untitled)

  • id (PK) — SERIAL — Primary key — NOT NULL
  • brand_name (Field) — varchar(50)
  • brand_logo (Field2) — text

brand_name_mapping (Untitled2)

  • id (PK) — SERIAL — Primary key — NOT NULL
  • extracted_brand_name (Field) — varchar(50)
  • preprocessed_brand_name (Field2) — varchar(50)
  • brand_id (FK) — integer — Foreign key → brand.id — NOT NULL

content_brand (Untitled3)

  • id (PK) — SERIAL — Primary key — NOT NULL
  • account_code (Field) — varchar(50)
  • content_code (Field2) — varchar(50)
  • brand_id (FK) — integer — Foreign key → brand.id — NOT NULL