flower-products

Tables (7)

Category (Untitled)

  • id (Key) — int — Primary key — NOT NULL — PK
  • name (Field) — str

Funeral (Untitled4)

  • id (Key) — int — Primary key — NOT NULL — PK
  • sidoCode (Key2) — str — Foreign key → SiDo.code — NOT NULL — UK
  • sigunguCode (Key23) — str — Foreign key → SiGunGu.code — NOT NULL — UK
  • name (Field) — str
  • address (Field2) — str

Product

  • id (Key) — int — Primary key — NOT NULL — PK
  • categoryId (Key2) — int — Foreign key → Category.id — NOT NULL — PK
  • recommandPrice (Field) — int
  • name (Field2) — str

ProductsOnFunerals (CopyOfUntitled5)

  • productId (Key) — int — Foreign key → Product.id — NOT NULL — FK
  • funeralId (Key2) — int — Foreign key → Funeral.id — NOT NULL — FK

ProductsOnSiGunGu (Untitled5)

  • productId (Key) — int — Foreign key → Product.id — NOT NULL — FK
  • sigunguCode (Key2) — str — Foreign key → SiGunGu.code — NOT NULL — FK

SiDo (Untitled2)

  • code (Key2) — str — Primary key — NOT NULL — UK

SiGunGu (Untitled3)

  • code (Key2) — str — Primary key — NOT NULL — UK
  • sidoCode (Key22) — str — Foreign key → SiDo.code — NOT NULL — UK