mission1
Tables (5)
Mission (Untitled3)
- mission_id (Key2) — BIGINT — Primary key — NOT NULL
- Store_id (Key) — BIGINT — Foreign key → store.Store_id — NOT NULL
- Regoin_id (Key22) — BIGINT — Foreign key → store.Regoin_id — NOT NULL
- name (Field2) — VARCHAR(20)
- Description (Field) — VARCHAR(20)
Region (Untitled5)
- Regoin_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
mission_history (Untitled2)
- Record_id (Key) — BIGINT — Primary key — NOT NULL
- id (Key3) — BIGINT — Foreign key → user.id — NOT NULL
- mission_id (Key22) — BIGINT — Foreign key → Mission.mission_id — NOT NULL
- mission_detail (Field) — TEXT
store (Untitled4)
- Store_id (Key) — BIGINT — Primary key — NOT NULL
- Regoin_id (Key2) — BIGINT — Foreign key → Region.Regoin_id — NOT NULL
- name (Field) — VARCHAR(20)
user (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
- create_at (Field2) — DATETIME
- update_at (Field3) — DATETIME
- status (Field4) — VARCHAR(20)
- address (Field5) — TEXT
- inactive_data (Field6) — DATETIME
- user_id (Field7) — VARCHAR(20)
- password (Field8) — VARCHAR(20)