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