scope1
Tables (4)
econ_term
- term_id — BIGINT
- term — VARCHAR(255) — NOT NULL
- definition — TEXT
- status — VARCHAR(32) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
keyword_anchor
- keyword_id — BIGINT
- keyword — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
roles
- role_id — INT
- role_name — VARCHAR(32) — NOT NULL
users
- user_id — BIGINT
- login_id — VARCHAR(64) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255)
- phone — VARCHAR(32)
- birth_date — DATE
- knowledge_level — VARCHAR(32)
- status — VARCHAR(32) — NOT NULL
- created_at — DATETIME — NOT NULL
- last_login_at — DATETIME