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