0330 homework_13

Tables (4)

Convenience (convenience)

  • Convenience id (convenience_id) — BIGINT — Primary key — NOT NULL
  • Name (name) — VARCHAR

Product field (product_field)

  • Field id (field_id) — BIGINT — Primary key — NOT NULL
  • Name (name) — VARCHAR

Products (products)

  • Product id (product_id) — BIGINT — Primary key — NOT NULL
  • Field id (field_id) — BIGINT — Foreign key → Product field.Field id — NOT NULL
  • Name (name) — VARCHAR

Products Interest (products_interest)

  • Convenience id (convenience_id) — BIGINT — Foreign key → Convenience.Convenience id — NOT NULL
  • Product id (product_id) — BIGINT — Foreign key → Products.Product id — NOT NULL