rooftown

Tables (5)

asset_character (Untitled2)

  • character_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • resource (Field2) — ...

asset_space_preset (Untitled)

  • preset_id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • resources — ... — map 생성에 필요한 여러가지 데이터들

mem_profile

  • profile_id (id) — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → user.user_id — NOT NULL — comment
  • character_id — INT
  • nickname — VARCHAR

room (space)

  • room_id (id) — INT — Primary key — NOT NULL
  • room_url (Field2) — VARCHAR — https://gather.town/app/ClvHx5fyu30wzUaL/tenuto_mvp 처럼 난독화된 무언가
  • title — VARCHAR — NOT NULL
  • desc — TEXT
  • purpose — VARCHAR
  • password (Field) — VARCHAR
  • preset_id (Key2) — INT — Foreign key → asset_space_preset.preset_id — NOT NULL
  • member_id (id2) — INT — Foreign key → user.user_id — NOT NULL — comment

user (member)

  • user_id (id) — INT — Primary key — NOT NULL — comment
  • user_provider (provider) — VARCHAR — NOT NULL
  • access_token — VARCHAR