djangoproject
Tables (5)
Accounts (account)
- id (아이디) — VARCHAR(255) — Primary key — NOT NULL
- password (비밀번호) — VARCHAR(255)
- name (이름) — VARCHAR(255)
- email (이메일) — VARCHAR(255)
- joindate (가입일자) — DATETIME
Products (product)
- product_number (상품번호) — INT — Primary key — NOT NULL
- store (가게) — VARCHAR(255) — Foreign key → producers.store — NOT NULL
- id (아이디) — VARCHAR(255) — Foreign key → producers.id — NOT NULL
- product_code (상품고유코드) — INT
- product_name (상품명) — VARCHAR(255)
- product_description (상품설명) — TEXT
- product_price (상품가격) — INT
- product_quantity (상품재고) — INT
- product_importdate (상품입고) — DATE — NOT NULL
- product_exportdate (상품출고) — DATE
Products (purchase)
- Basket (장바구니) — VARCHAR(255) — Primary key — NOT NULL
- product_number (상품번호) — INT — Foreign key → Products.product_number — NOT NULL
- store (가게) — VARCHAR(255) — Foreign key → Products.store — NOT NULL
- id (아이디) — VARCHAR(255) — Foreign key → Products.id — NOT NULL
- home (집) — VARCHAR(255) — Foreign key → customers.home — NOT NULL
- id (아이디2) — VARCHAR(255) — Foreign key → customers.id — NOT NULL
customers (customer)
- home (집) — VARCHAR(255) — Primary key — NOT NULL
- id (아이디) — VARCHAR(255) — Foreign key → Accounts.id — NOT NULL
- address (집주소) — VARCHAR(255)
- phonenumber (연락처) — INT
producers (producer)
- store (가게) — VARCHAR(255) — Primary key — NOT NULL
- id (아이디) — VARCHAR(255) — Foreign key → Accounts.id — NOT NULL
- address (가게주소) — VARCHAR(255)
- storenumber (가게번호) — VARCHAR(255)