2
Tables (4)
accountlikes
- id — int(10) — Foreign key → posts.id — NOT NULL
- name — varchar(20) — Foreign key → accounts.name — NOT NULL
- Key — Foreign key → posts.Key — NOT NULL
- Key (Key2) — Foreign key → accounts.Key — NOT NULL
accounts
- name — varchar(20) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- isAdmin — tinyint(4) — NOT NULL
- isIgnore — tinyint(4) — NOT NULL
- mypage
comments
- comments_id — int(10) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- author — varchar(20) — NOT NULL
- content — varchar(50) — NOT NULL
- wtime — datetime — NOT NULL
- name — varchar(20) — Foreign key → accounts.name — NOT NULL
- rank — int(10) — Foreign key → posts.id — NOT NULL
- Key (Key2) — Foreign key → posts.Key — NOT NULL
- Key (Key3) — Foreign key → accounts.Key — NOT NULL
posts
- id — int(10) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- author — varchar(20) — NOT NULL
- title — varchar(20) — NOT NULL
- content — text — NOT NULL
- wtime — datetime — NOT NULL
- isNotice — tinyint(4) — NOT NULL
- isAdminAuthor — tinyint(4) — NOT NULL
- name — varchar(20) — Foreign key → accounts.name — NOT NULL
- Key (Key2) — Foreign key → accounts.Key — NOT NULL