bmtown
Tables (3)
OBJECT (사물)
- oid (Key) — INT — Primary key — NOT NULL
- image (이미지 URL) — VARCHAR
- uid (생성자) — INT — Foreign key → USER.uid — NOT NULL
- rid (생성된 방) — INT — Foreign key → ROOM.rid — NOT NULL
- x (물체가 놓인 좌상단 x좌표) — INT
- y (물체가 놓인 좌상단 y좌표) — INT
ROOM (방)
- rid (Key) — INT — Primary key — NOT NULL
- image (룸 배경화면 URL) — VARCHAR
- title (룸 이름) — VARCHAR
USER (유저)
- uid (Key) — INT — Primary key — NOT NULL
- id (아이디) — VARCHAR
- password (비밀번호) — VARCHAR
- github_id (깃허브 아이디) — VARCHAR
- last_online (Field) — DATETIME