P4: bmtown
Tables (6)
Maps (mapInfo)
- maps_id (map_id) — INT — Primary key — NOT NULL
- maps_img (map_img) — VARCHAR(200)
Room (생성된map들)
- room_id — INT — Primary key — NOT NULL
- map_id — INT — Foreign key → Maps.maps_id — NOT NULL
- room_name — string
Stuff (물건info)
- stuff_id — INT — Primary key — NOT NULL
- stuff_img — VARCHAR(200)
User (사용자)
- id — VARCHAR(45) — Primary key — NOT NULL
- nickname — VARCHAR(45) — NOT NULL
- user-img (Field) — VARCHAR(200)
roomStuff (맵에 들어간 물건들)
- room_id — INT — Foreign key → Room.room_id — NOT NULL
- map_id — INT — Foreign key → Room.map_id — NOT NULL
- stuff_id (object_id) — INT — Foreign key → Stuff.stuff_id — NOT NULL
- positon_x — INT
- postion_y — INT
- object_type — INT
userSpace (유저의방기록)
- id (autoIncretmentId) — int — Primary key — NOT NULL
- userId (id2) — VARCHAR(45) — Foreign key → User.id — NOT NULL
- room_id (room_id2) — INT — Foreign key → Room.room_id — NOT NULL
- map_id (map_id2) — INT — Foreign key → Room.map_id — NOT NULL