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