helper

Tables (3)

article

  • id (Field) — praimary — Primary key
  • user_id (Key) — not null — Foreign key → user.id — NOT NULL
  • article_list_id (Key2) — fk(on update cascade on delete set null) — Foreign key → article_list.id — NOT NULL
  • title (Field2) — not null
  • content (Field3) — not null
  • create_date (Field4) — not null
  • update_date (Field5) — null
  • hits (Field6) — not null

article_list

  • id (Key) — praimary — Primary key — NOT NULL
  • title (Field) — not null
  • create_date (Field2) — not null

user

  • id (Key) — praimary — Primary key — NOT NULL
  • user_id (Field5) — not null
  • nick_name (Field) — not null
  • password (Field2) — not null
  • join_date (Field3) — null
  • position (Field4) — not null