ERD
Tables (5)
department
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
imurecord
- id — INT — Primary key — NOT NULL
- code — VARCHAR(32) — NOT NULL — 외부 노출용 코드(숫자문자열, zero-fill)
- serial — VARCHAR(100)
- inspected_at — DATETIME — NOT NULL
- passed — TINYINT(1) — NOT NULL
- inspector_id — INT — NOT NULL
- box_no — INT
- destination — VARCHAR(255)
- arrived — TINYINT(1) — NOT NULL
- roll — DOUBLE
- pitch — DOUBLE
- yaw — DOUBLE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
logintoken
- token — CHAR(36) — Primary key — NOT NULL
- user_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
position
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
user
- id — INT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)
- department_id — INT
- position_id — INT
- phone — VARCHAR(32)
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL