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