cotato-weather

Tables (3)

Location (위치)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(20)
  • latitude (위도) — double
  • longitude (경도) — double
  • member_id (회원 Key) — bigint — Foreign key → Member.id — NOT NULL

Member (회원)

  • id (Key) — bigint — Primary key — NOT NULL
  • username (유저 이름) — varchar(20)
  • password (비밀번호) — varchar(20)

Pin (위치 핀)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (회원 Key) — bigint — Foreign key → Member.id — NOT NULL
  • location_id (위치 Key) — bigint — Foreign key → Location.id — NOT NULL
  • created_at (생성 시간) — LocalDateTime