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