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