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)