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