smart device
Tables (7)
admin (Untitled)
- id — int — Primary key — NOT NULL — pk
- user name (user) — varchar — NOT NULL
- password — varchar — NOT NULL
- role — varchar — NOT NULL — 관리자 등급
- last at (last_at) — DATETIME — NOT NULL
- status — VARCHAR — NOT NULL — 로그인 상태
- company — int — Foreign key → company.id — NOT NULL — 등록 회사 pk
- team — int — Foreign key → team.id — NOT NULL — 소속 팀
company (Untitled2)
- id — int — Primary key — NOT NULL
- company name (name)
- code — VARCHAR — NOT NULL — 회사 코드
- type — VARCHAR — NOT NULL — 타입(버전) 선택
device (Untitled4)
- id — int — Primary key — NOT NULL
- uid — VARCHAR — NOT NULL
- last_at — DATETIME
- status — VARCHAR — NOT NULL
- call_status — VARCHAR — NOT NULL
- latitude — VARCHAR
- longitude — VARCHAR
- 기기 별칭 (name) — VARCHAR — NOT NULL
- 아고라 채널명 (channel_name) — VARCHAR — NOT NULL
- 팀 (team) — int — Foreign key → team.id
- 소속 회사 (company) — int — Foreign key → company.id — NOT NULL
device_login (Untitled5)
- id — int — Primary key — NOT NULL — 로그인데이터 pk
- login_date (timestamp)
- refresh_token — VARCHAR
- 리프레시 토큰 만료기간 (refresh_token_expiration) — DATETIME
- 디바이스 id (device_id) — int — Foreign key → device.id — NOT NULL — 로그인 id pk
image (Untitled6)
- id — int — Primary key — NOT NULL
- name — VARCHAR
- 경로 (file_path) — VARCHAR — 실제 저장경로
- 저장일자 (created_at) — DATETIME
- memo — VARCHAR
- 촬영한 device (device) — int — Foreign key → device.id — NOT NULL
- team — int — Foreign key → team.id — NOT NULL
- company — int — Foreign key → company.id — NOT NULL
team (Untitled3)
- id — int — Primary key — NOT NULL
- company_id (company) — int — Foreign key → company.id — NOT NULL — 회사 pk
- type — VARCHAR — NOT NULL
video (CopyOfUntitled6)
- video (id) — int — Primary key — NOT NULL
- name — VARCHAR
- 경로 (file_path) — VARCHAR — 실제 저장경로
- 저장일자 (created_at) — DATETIME
- memo — VARCHAR
- 촬영한 device (device) — int — Foreign key → device.id — NOT NULL
- team — int — Foreign key → team.id — NOT NULL
- company — int — Foreign key → company.id — NOT NULL