exec1
Tables (5)
component (Untitled3)
- c_id (Key) — int — Primary key — NOT NULL
- s_name (key) — VARCHAR(10) — Foreign key → supply.s_name — NOT NULL
- info (Field) — VARCHAR(45)
- c_name (Field4) — VARCHAR(10)
manufacturer (Untitled)
- m_name (Key) — varchar(10) — Primary key — NOT NULL
product (Untitled2)
- p_id (Key) — int — Primary key — NOT NULL
- m_name (Key2) — varchar(10) — Foreign key → manufacturer.m_name — NOT NULL
- p_name (Field) — VARCHAR(10)
- count (Field3) — int
supplier (Untitled5)
- s_name (key) — VARCHAR(10) — Primary key — NOT NULL
supply (Untitled4)
- s_name (key) — VARCHAR(10) — Foreign key → supplier.s_name — NOT NULL
- p_id (Field2) — int