edu

Tables (7)

Adress (Untitled7)

  • adrs_id (Key) — Primary key — NOT NULL
  • 시도_code (Field)
  • 시도_nm (Field2)
  • 시군구_code (Field3)
  • 시군구_nm (Field4)
  • 행정동_code (Field5)
  • 행정동_nm (Field6)

Calendar (Untitled3)

  • date_id (Key2) — Primary key — NOT NULL
  • month_id (Field5)
  • year_id (Field4)
  • dayofweek_id (Field)
  • bsns_yn (Field2)

Customer (Untitled6)

  • cust_id (Key) — Primary key — NOT NULL
  • cust_nm (Field)
  • btdt (Field2)
  • age (Field3)
  • adrs_id (Field4)
  • valid_yn (Field5)

Inventory (Untitled)

  • month_id (Key) — Primary key — NOT NULL
  • store_id (Key2) — Primary key — NOT NULL
  • item_id (Key3) — Primary key — NOT NULL
  • inv_amt (Field)
  • inv_units (Field2)

Item (Untitled5)

  • item_id (Key) — Primary key — NOT NULL
  • item_nm (Field)
  • item_ordr (Field2)
  • category_dvsn_code (Field3)
  • category_nm (Field4)
  • origin_code (Field5)

Sales (Untitled2)

  • sale_date (Key) — Primary key — NOT NULL
  • store_id (Key2) — Primary key — NOT NULL
  • item_id (Key3) — Primary key — NOT NULL
  • cust_id (Key4) — Primary key — NOT NULL
  • sale_amt (Field)
  • sale_units (Field2)

Store (Untitled4)

  • store_id (Key) — Primary key — NOT NULL
  • store_nm (Field)
  • store_ordr (Field2)
  • store_adds (Field3)
  • store_phn_nmb (Field4)
  • store_dvsn_code (Field5)