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