Report1
Tables (4)
Customer (고객)
- id (Key) — int — Primary key — NOT NULL
- product_id (Key2) — int — Foreign key → Product.id — NOT NULL
- name (Field) — string
- phone_number (Field2) — int
- address (Field3) — string
- birthday (Field4) — int
- job (Field5) — string
Employee (직원)
- id (Key) — int — Primary key — NOT NULL
- manufacturer_id (Key2) — int — Foreign key → Manufacturer.id — NOT NULL
- name (Field) — string
- gender (Field2) — string
- division (Field3) — string
- employment_date (Field4) — int
Manufacturer (제조사)
- id (Key) — int — Primary key — NOT NULL
- company_name (Field) — string
- address (Field2) — string
- postal_number (Field3) — int
- phone_number (Field4) — int
- home_page (Field5) — string
- email_address (Field6) — string
- location (Field7) — string
- distance (Field8) — int
Product (상품)
- id (Key) — int — Primary key — NOT NULL
- manufacturer_id (Key2) — int — Foreign key → Manufacturer.id — NOT NULL
- name (Field) — string
- description (Field2) — string
- selling_price (Field3) — int
- supply_price (Field6) — int
- manufactured_date (Field4) — int
- expiration_date (Field5) — int
- category (Field7) — string
- order_date (Field8) — int
- order_quantity (Field9) — int
- total_cost (Field10) — int