products

Tables (6)

Branch (지점)

  • branch_id (지점번호) — AutoField — Primary key — NOT NULL
  • name (상호명) — CharField — NOT NULL — max_length=30
  • supervisor (대표자) — CharField — NOT NULL — max_length=20
  • address (주소) — CharField — NOT NULL — (max_length=30)
  • phonenumber (전화번호) — CharField — NOT NULL — max_length=20

Employee (직원)

  • employee_id (직원번호) — IntegerField — Primary key — NOT NULL
  • branch_id (지점번호) — AutoField — Foreign key → Branch.branch_id — NOT NULL
  • supervisor_id (대표자번호) — AutoField — Foreign key → Supervisor.supervisor_id — NOT NULL
  • name (직원이름) — CharField — NOT NULL — max_length=10
  • adress (주소) — CharField — NOT NULL — max_length=20
  • account_number (계좌번호) — CharField — NOT NULL — max_length=20
  • phonenumber (직원전화번호) — CharField — NOT NULL — max_length=20

Factory (물류센터)

  • factory_id (물류센터번호) — AutoField — Primary key — NOT NULL
  • phonenumber (물류센터전화번호) — NOT NULL
  • adress (물류센터주소) — CharField — NOT NULL — max_length=30

Reservation (구매)

  • date (구입일) — DateTimeField — NOT NULL
  • branch_id (지점번호) — AutoField — Foreign key → Branch.branch_id — NOT NULL
  • item_id (상품번호) — AutoField — Foreign key → item.item_id — NOT NULL

Supervisor (대표자)

  • supervisor_id (대표자번호) — AutoField — Primary key — NOT NULL
  • branch_id (지점번호) — AutoField — Foreign key → Branch.branch_id — NOT NULL
  • employee_id (직원번호) — IntegerField — NOT NULL
  • name (대표자이름) — CharField — NOT NULL — max_length=10
  • phonenumber (대표자전화번호) — CharField — NOT NULL — max_length=20
  • area (담당구역) — CharField — NOT NULL — max_length=20

item (상품)

  • item_id (상품번호) — AutoField — Primary key — NOT NULL
  • factory_id (물류센터번호) — AutoField — Foreign key → Factory.factory_id — NOT NULL
  • name (상품이름) — CharField — NOT NULL — max_length=10
  • buy_price (매입가) — IntegerField — NOT NULL
  • sell_price (매출가) — IntegerField — NOT NULL
  • stack (재고) — IntegerField — NOT NULL