Project

Tables (5)

Comment (Untitled3)

  • id — long — Primary key — NOT NULL
  • text — varchar — NOT NULL
  • post_id — long — Foreign key → Post.id — NOT NULL
  • user_id — long — Foreign key → User.id — NOT NULL

Location (Untitled4)

  • id — long — Primary key — NOT NULL
  • location — varchar — NOT NULL
  • code — varchar — NOT NULL

Post (Untitled2)

  • id — long — Primary key — NOT NULL
  • postname — varchar — NOT NULL
  • content — varchar — NOT NULL
  • createdAt — time — NOT NULL
  • uset_id (user_id) — long — Foreign key → User.id — NOT NULL
  • modifiedAt — time — NOT NULL
  • img — varchar

Time (Untitled5)

  • Key — Primary key — NOT NULL
  • Field
  • Field2

User (Untitled)

  • id — long — Primary key — NOT NULL
  • username — varchar(50) — NOT NULL
  • password — varchar(50) — NOT NULL
  • desc — varchar(100)
  • location — varchar(100) — NOT NULL
  • location_id — long — Foreign key → Location.id — NOT NULL
  • nickname — varchar(200)