DeliveryManagement

DeliveryManagement Data Modeling

Tables (4)

Accounts (ACCOUNTS)

  • Key (idx_a) — NUMBER(10, 0) — Primary key — NOT NULL — Auto Increment by using sequence
  • Field (grade) — NUMBER(3, 0) — NOT NULL — (Customer 1, Company 2, Admin 99)
  • Field (account) — VARCHAR2(15) — NOT NULL — ID
  • Field (password) — VARCHAR2(100) — NOT NULL — Password, Encrypted by SHA-256
  • Field (address) — VARCHAR2(100) — NOT NULL — Address
  • Field (company) — VARCHAR2(40) — Company Name
  • Field (phone) — VARCHAR2(20) — Phone Number
  • Field2 (point) — NUMBER(10, 0) — Point
  • Field3 (created_at) — TIMESTAMP(6) — NOT NULL — Created time
  • Field4 (updated_at) — TIMESTAMP(6) — NOT NULL — Updated time

Untitled (STORES)

  • Key (idx_s) — NUMBER(10, 0) — Primary key — NOT NULL — Auto Increment by using sequence
  • Key (idx_a) — NUMBER(10, 0) — Foreign key → Accounts.Key — NOT NULL — Auto Increment by using sequence
  • Field (name) — VARCHAR2(40) — NOT NULL — Store Name
  • Field (methods) — VARCHAR2(40) — NOT NULL — Payment Methods
  • Field2 (created_at) — TIMESTAMP(6) — NOT NULL — Created time
  • Field3 (updated_at) — TIMESTAMP(6) — NOT NULL — Updated time

Untitled (FOODS)

  • Key (idx_f) — NUMBER(10, 0) — Primary key — NOT NULL — Auto Increment by using sequence
  • Key (idx_s) — NUMBER(10, 0) — Foreign key → Untitled.Key — NOT NULL — Auto Increment by using sequence
  • Field (food) — VARCHAR2(40) — NOT NULL — Food Name
  • Field2 (price) — NUMBER(10, 0) — NOT NULL — Food Price
  • Field3 (created_at) — TIMESTAMP(6) — NOT NULL — Created time
  • Field4 (updated_at) — TIMESTAMP(6) — NOT NULL — Updated time

Untitled (ORDERS)

  • Key (idx_o) — NUMBER(10, 0) — Primary key — NOT NULL — Auto Increment by using sequence
  • Key (idx_a) — NUMBER(10, 0) — Foreign key → Accounts.Key — NOT NULL — Auto Increment by using sequence
  • Key (idx_s) — NUMBER(10, 0) — Foreign key → Untitled.Key — NOT NULL — Auto Increment by using sequence
  • Field (foods) — LONG — NOT NULL — Ordered food
  • Field (duration) — NUMBER(3, 0) — Expected delivery time
  • Field (comments) — VARCHAR2(200) — Comments
  • Field (method) — VARCHAR2(10) — NOT NULL — Payment Method
  • Field (created_at) — TIMESTAMP(6) — NOT NULL — Created time
  • Field (updated_at) — TIMESTAMP(6) — NOT NULL — Updated time