EB-sDB
Tables (6)
Favorite_place (favorite_place)
- favorite_place_uid (Key) — Primary key — NOT NULL
- member_uid (Key4) — Foreign key → Member.member_uid — NOT NULL
- category (Field)
- info (Key2) — NOT NULL
- lng (Field2)
- lat (Field3)
Member (member)
- member_uid (Key) — Primary key — NOT NULL
- id (Field)
- password (Field2)
- name (Field3)
- refreshToken (Field5)
- salt (Field4)
- device_token (Field6)
Path (path)
- path_uid (Key) — Primary key — NOT NULL
- schedule_uid (Key2) — Foreign key → Schedule.schedule_uid — NOT NULL
- member_uid (Key22) — Foreign key → Schedule.member_uid — NOT NULL
- total_time (Field)
- totla_pay (Field2)
- total_transit_count (Field3)
- total_walk_time (Field4)
- path_type (Field5)
Schedule (schedule)
- schedule_uid (Key) — Primary key — NOT NULL
- member_uid (Key2) — Foreign key → Member.member_uid — NOT NULL
- name (Field)
- memo (Field2)
- start_date (Field3)
- start_address_name (Field4)
- start_lng (Field5)
- start_lat (Field6)
- end_address_name (Field7)
- end_lng (Field8)
- end_lat (Field9)
- notice_range (Field10)
- notice_min_before_transport_arrive (Field11)
- must_be_notify (Field12)