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