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