ERD-DB class

Tables (6)

Untitled (Article)

  • Key (article_id) — NOT NULL — Primary key — NOT NULL
  • Key (register_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Key (apply_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — NOT NULL
  • Field (last_updated) — NOT NULL
  • Field (view_count) — NOT NULL
  • Field (text) — NULL
  • Field (recruit_type) — NOT NULL
  • Field (apply_count) — NOT NULL

Untitled (Apply)

  • Key (apply_id) — NOT NULL — Primary key — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Field (apply_date) — NOT NULL

Untitled (Register)

  • Key (register_id) — NOT NULL — Primary key — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Field (register_date) — NOT NULL
  • Field (company_name) — NOT NULL

Untitled (confirm_email)

  • Key (confirm_email_id) — NOT NULL — Primary key — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Field (date_expired) — NOT NULL
  • Field2 (email) — NOT NULL
  • Field (secured_key) — NOT NULL

Untitled (logged_in)

  • Key (logged_in_id) — NOT NULL — Primary key — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → User.Key — NOT NULL
  • Field (date_create) — NOT NULL
  • Field (remote_addr) — NOT NULL

User

  • Key (user_id) — NOT NULL — Primary key — NOT NULL
  • Field (login_id) — NOT NULL — NOT NULL
  • Field2 (name) — NOT NULL
  • Field3 (password) — NOT NULL
  • Field4 (create_ip) — NOT NULL
  • Field (user_type) — NOT NULL
  • Field (date_create) — NOT NULL
  • Field (acount_expired) — NOT NULL
  • Field (acount_locked) — NOT NULL