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