nest
Tables (7)
Announcements (Untitled7)
- threadId (Key) — int — Primary key — NOT NULL
- title (Field) — varchar(255) — NOT NULL
- createDate (Field2) — int — NOT NULL
- url (Field3) — varchar(255) — NOT NULL
Articles (Untitled4)
- article_id (Key) — int — Primary key — NOT NULL
- author (Key3) — varchar(40) — Foreign key → Users.id — NOT NULL — FK(Users)
- title (Field) — text — NOT NULL
- content (Field2) — longtext — NOT NULL
- post_date (Field3) — date — NOT NULL
- update_date (Field4) — date — NOT NULL
Comments (Untitled5)
- comment_id (Key) — int — Primary key — NOT NULL
- article_id (Key3) — int — Foreign key → Articles.article_id — NOT NULL — FK(Articles)
- author (Field) — varchar(40) — NOT NULL
- time (Field2) — date — NOT NULL
- depth (Field3) — int — NOT NULL
- comment_order (Field4) — int — NOT NULL
- group_num (Field5) — int — NOT NULL
- content (Field6) — text — NOT NULL
Lessons (Untitled6)
- title (Key) — varchar(20) — Primary key — NOT NULL
- lesson (Field) — varchar(255) — NOT NULL
Parties (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- title (Field) — varchar(100)
- limit (Field2) — int
- time (Field3) — timestamp
PartyMembers; (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- userId (Key4) — varchar(40) — Foreign key → Users.id — NOT NULL — FK(Users)
- partyId (Key2) — int — Foreign key → Parties.id — NOT NULL — FK(Parties)
- order (Field) — int — NOT NULL
- Field2
Users (Untitled)
- id (Key) — varchar(40) — Primary key — NOT NULL
- name (Field) — varchar(40) — NOT NULL
- password (Field2) — varchar(255) — NOT NULL
- address (Field3) — varchar(100) — NOT NULL
- phone_number (Field4) — varchar(20) — NOT NULL