HM ERD

Tables (6)

Copy Of Copy Of Untitled (sdm_vendor)

  • Key (sdm_vendor_id) — INT — Primary key — NOT NULL
  • Field (sdm_vendor_name) — VARCHAR(100)
  • Field (address) — VARCHAR(255)
  • Field (price) — INT
  • Field (rate) — FLOAT

Copy Of Untitled (studio)

  • Key (studio_id) — INT — Primary key — NOT NULL
  • Field (studio_name) — VARCHAR(100)
  • Field (address) — VARCHAR(255)
  • Field (price) — INT
  • Field (rate) — FLOAT

Untitled (wedding_venue)

  • Key (venue_id) — INT — Primary key — NOT NULL
  • Field (venue_name) — VARCHAR(100)
  • Field (address) — VARCHAR(255)
  • Field (price) — INT
  • Field (rate) — FLOAT

Untitled (planner)

  • Key (planner_id) — INT — Primary key — NOT NULL
  • Key (venue_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (studio_id) — INT — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (sdm_vendor_id) — INT — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL
  • User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL

Untitled (invitation_card)

  • Key (invitation_card_id) — INT — Primary key — NOT NULL
  • Field (design_id) — INT
  • Field (spouse_name) — VARCHAR(50)
  • Field (priest_name) — VARCHAR(50)
  • Field (message) — VARCHAR(255)
  • Field (wedding_date) — DATETIME
  • Field (address) — VARCHAR(255)
  • User Id (user_id) — INT — Foreign key → User.User Id — NOT NULL

User (user)

  • User Id (user_id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR(50)
  • Login Id (login_id) — VARCHAR(50)
  • Password (password) — VARCHAR(100)
  • Created At (created_at) — DATETIME