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