DongSan
Tables (8)
Comment (Untitled5)
- comment_id (Key) — INT — Primary key — NOT NULL
- content (Field) — VARCHAR
- created_at (Field2) — DATETIME
- member_id (INT) — INT — Foreign key → Member.member_id — NOT NULL
- walking_id (Key2) — INT — Foreign key → Walking.walking_id — NOT NULL
Keyword (Untitled2)
- keyword_id (Key) — INT — Primary key — NOT NULL
- content (Field) — VARCHAR
Like_Keyword (Untitled3)
- member_id (INT) — INT — Foreign key → Member.member_id — NOT NULL
- keyword_id (Key) — INT — Foreign key → Keyword.keyword_id — NOT NULL
Like_Walk (Untitled7)
- member_id (INT) — INT — Foreign key → Member.member_id — NOT NULL
- walking_id (Key) — INT — Foreign key → Walking.walking_id — NOT NULL
Member (Untitled)
- member_id (INT) — INT — Primary key — NOT NULL
- name (Field2) — VARCHAR
- email (Field3) — VARCHAR
- password (Field7) — VARCHAR
- profile_image_url (Field) — VARCHAR
- present_location_name (Field4) — VARCHAR
- present_location_lat (Field5) — FLOAT
- present_location_long (Field6) — FLOAT
Route (Untitled8)
- route_id (Key) — INT — Primary key — NOT NULL
- order (Field) — INT
- lat (Field2) — FLOAT
- long (Field3) — FLOAT
- walking_id (Key2) — INT — Foreign key → Walking.walking_id — NOT NULL
Walk_Keyword (Untitled6)
- walking_id (Key) — INT — Foreign key → Walking.walking_id — NOT NULL
- keyword_id (Key2) — INT — Foreign key → Keyword.keyword_id — NOT NULL
Walking (Untitled4)
- walking_id (Key) — INT — Primary key — NOT NULL
- is_public (Field) — BOOLEAN
- title (Field4) — VARCHAR
- created_at (Field2) — DATE
- distance (Field3) — FLOAT
- time (Field5) — TIME
- content (Field14) — VARCHAR
- start_location_lat (Field6) — FLOAT
- start_location_long (Field7) — FLOAT
- start_location_name (Field8) — VARCHAR
- end_location_lat (Field9) — FLOAT
- end_location_long (Field10) — FLOAT
- end_location_name (Field11) — VARCHAR
- total_like (Field12) — INT
- total_comment (Field13) — INT
- member_id (INT) — INT — Foreign key → Member.member_id — NOT NULL