erd

Tables (5)

RefreshToken (Untitled5)

  • ID (Key) — Long — Primary key — NOT NULL
  • ID (Key2) — Long — Foreign key → member.ID — NOT NULL
  • valuekey (Field) — String

comment (Untitled3)

  • commentId (Key3) — Long — Primary key — NOT NULL
  • postid (Key) — Long — Foreign key → post.postId — NOT NULL
  • Rid (Key32) — Long — Foreign key → post.Rid — NOT NULL
  • author (Field) — String
  • content (Field2) — String

member (Untitled)

  • ID (Key) — Long — Primary key — NOT NULL
  • ID (Field) — String
  • Password (Field2) — String
  • nickname (Field3) — String

post (Untitled2)

  • postId (Key) — Long — Primary key — NOT NULL
  • ID (Key2) — Long — Foreign key → member.ID — NOT NULL
  • Rid (Key3) — Long — Foreign key → restaurant.Rid — NOT NULL
  • author (Field) — String
  • title (Field2) — String
  • content (Field3) — String
  • imgurl (Field4) — URL

restaurant (Untitled4)

  • Rid (Key) — Long — Primary key — NOT NULL
  • coordinatex (Field) — String
  • coordinatey (Field2) — String