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