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