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)