projectd
Tables (8)
chats (Untitled5)
- PK (ID) — Long — Primary key — NOT NULL
- Field (title) — varchar(10)
- Field (message) — varchar
- Field (check) — boolean
- Field (updated_at) — datetime
friend (Untitled9)
- PK (ID) — Long — Foreign key → members.PK — NOT NULL
join_member (Untitled6)
- PK (ID) — Long — Foreign key → member.PK — NOT NULL
- PK (ID2) — Long — Foreign key → chats.PK — NOT NULL
member (Untitled)
- PK (ID) — Long — Primary key — NOT NULL
- Field (name) — Varchar(10)
- Field (Gender) — Int
- Field (age) — Int
- Field (Status) — varchar(15)
- Field (inactive_date) — datetime
- Field (socialType) — varchar(10)
- Field (create_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (email) — varchar(50)
- Field (point) — int
- Field (level) — Int
members (Untitled8)
- PK (ID) — Long — Foreign key → member.PK — NOT NULL
message (Untitled7)
- PK (ID) — Long — Primary key — NOT NULL
- PK (ID2) — Long — Primary key — NOT NULL
- Field (body) — text
- Field (send_time) — timestamp
- Field (check) — boolean
- PK (ID22) — Long — Foreign key → join_member.PK — NOT NULL
plan (Untitled4)
- PK (ID) — Long — Primary key — NOT NULL
- Field (title) — varchar(50)
- Field (body) — text
- Field (locate) — varchar(50)
- PK (ID2) — Long — Foreign key → member.PK — NOT NULL
post (Untitled2)
- PK (ID) — Long — Primary key — NOT NULL
- Field (title) — varchar(50)
- Field (body) — text
- Field (created_at) — datetime
- Field (update_at) — datetime
- PK (ID2) — Long — Foreign key → member.PK — NOT NULL