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