PostureLive

Tables (9)

all.users (namu_auth.users)

  • id — int — Primary key — NOT NULL — user's id
  • email — varchar(50) — NOT NULL
  • password — varchar(100) — NOT NULL
  • user_name — varchar(50) — NOT NULL

g_manager

  • gid — int — Foreign key → groups.id — NOT NULL — group's id
  • uid — int — Foreign key → all.users.id — NOT NULL — user's id

g_user

  • id (gid) — int — Foreign key → groups.id — NOT NULL — group's id
  • id (uid) — int — Foreign key → all.users.id — NOT NULL — user's id
  • invited_at — DATETIME — NOT NULL — 초대받은 시각
  • member_since — DATETIME — 그룹에 가입한 시각
  • id (pg_id) — INT — Foreign key → programs.id — NOT NULL — program's id

groups

  • id — int — Primary key — NOT NULL — group's id
  • title — varchar(30) — NOT NULL — group's title
  • desc — VARCHAR(100) — group's description
  • created — DATETIME — NOT NULL — 생성 시각

masters

  • id — int — Foreign key → all.users.id — NOT NULL — user's id

pg_device_param

  • id (pid) — INT — Foreign key → programs.id — NOT NULL — program's id
  • cfg — VARCHAR(500) — NOT NULL — 모든 제품에 대응 가능하도록, Object를 텍스트로 변환하여 저장. 예)"{vib: true, vib_length: 10}"

pg_mission

  • id — INT — Foreign key → programs.id — NOT NULL — program's id

product

  • id — INT — Primary key — NOT NULL — product's id
  • title — VARCHAR(20) — product's name

programs

  • id — INT — Primary key — NOT NULL — program's id
  • gid — INT — Foreign key → groups.id — NOT NULL — group's id
  • title — VARCHAR(50) — NOT NULL — program's title
  • start_date — DATETIME — 프로그램 시작시각
  • end_date — DATETIME — 프로그램 종료시각
  • prd_type — INT — Foreign key → product.id — NOT NULL — 프로그램에서 사용할 제품의 id