MoA

Tables (6)

Posts

  • pid — INT — Primary key — NOT NULL
  • uid — INT
  • content — TEXT
  • userCount — INT
  • postTime — TIMESTAMP
  • img — TEXT
  • link — TEXT
  • attendent — INT

Users

  • uid — INT — Primary key — NOT NULL
  • userID — VARCHAR(20)
  • password — VARCHAR(32)
  • nickname — VARCHAR(20)
  • email — VARCHAR(30)
  • introduce — VARCHAR(200)
  • cLoc — TEXT
  • cSchool — TEXT
  • cAge — TEXT
  • profileImg — TEXT

categories

  • cid — INT — Primary key — NOT NULL
  • type — INT
  • name — VARCHAR(10)

emojis

  • eid — INT — Primary key — NOT NULL
  • value — INT

post_categories

  • pid — INT — Primary key — NOT NULL
  • cid — INT — Primary key — NOT NULL

post_emojis

  • pid — INT — Primary key — NOT NULL
  • eid — INT — Primary key — NOT NULL
  • count — INT