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