test
Tables (6)
article
- ID — int — Primary key — NOT NULL
- user_ID — int — NOT NULL
- date — datetime — NOT NULL
- content — varchar(255) — NOT NULL
- reply — int
- likes — int
bookmark
- ID — int — Primary key — NOT NULL
- article_ID — int — NOT NULL
- user_ID — int — NOT NULL
- date — datetime — NOT NULL
comment
- ID — int — Primary key — NOT NULL
- user_ID — int — NOT NULL
- article_ID — int — NOT NULL
- content — varchar(127) — NOT NULL
- date — datetime — NOT NULL
following
- ID — int — Primary key — NOT NULL
- following_ID — int — NOT NULL
- follower_ID — int — NOT NULL
- date — datetime — NOT NULL
likes
- ID — int — Primary key — NOT NULL
- article_ID — int — NOT NULL
- user_ID — int — NOT NULL
user
- ID — int — Primary key — NOT NULL
- username — varchar(63) — NOT NULL
- password — varchar(31) — NOT NULL
- phone_num — varchar(31) — NOT NULL
- name — varchar(63) — NOT NULL
- email — varchar(127) — NOT NULL
- brith_date — date — NOT NULL
- create_date — datetime — NOT NULL