Haeru-World

Tables (3)

HaeruPlace (해루질 장소)

  • haeru_place_id; (해루질장소 식별자) — NOT NULL — Primary key — NOT NULL
  • name (장소명) — NOT NULL
  • address (주소) — NOT NULL
  • area (지역) — NOT NULL
  • latitude (위도) — NOT NULL
  • longitude (경도) — NOT NULL
  • markerPositionX (이미지 x) — NOT NULL
  • markerPositionY (이미지 y) — NOT NULL
  • HaeruPlaceMarineCollectionId (식별자2) — NOT NULL — Foreign key → HaeruPlaceMarineCollection.HaeruPlaceMarineCollectionId — NOT NULL

HaeruPlaceMarineCollection (해루질장소 해양채집물)

  • HaeruPlaceMarineCollectionId (식별자) — NOT NULL — Primary key — NOT NULL

MarineCollection (해양 채집물)

  • marine_collection_id (해양채집물 식별자) — NOT NULL — Primary key — NOT NULL
  • name (해양채집물 이름) — NOT NULL
  • image_url (해양채집물 이미지) — NOT NULL
  • HaeruPlaceMarineCollectionId (식별자2) — NOT NULL — Foreign key → HaeruPlaceMarineCollection.HaeruPlaceMarineCollectionId — NOT NULL