Bo_Protect
Tables (5)
1:1qna
- qna_id — int — Primary key — NOT NULL — auto_increment
- company_id — int — Primary key — NOT NULL — auto_increment
- company_name — varchar(200) — NOT NULL
- manager_name (Field) — varchar(100) — NOT NULL
- request_content — varchar(2000) — NOT NULL
- company_email — varchar(500) — NOT NULL
- contact — varchar(20) — NOT NULL
- sms_consent — char(1) — NOT NULL — CHECK (sms_consent IN ('Y', 'N'))
- call_consent — char(1) — NOT NULL — CHECK (call_consent IN ('Y', 'N'))
- q_date — datetime — NOT NULL
- qna_status — varchar(20) — NOT NULL — CHECK (status IN ('completed', 'in_progress', 'before'))
agent
- agent_key — int — Primary key — NOT NULL — auto_increment
- agent_id — varchar(100) — Primary key — NOT NULL
- agent_name — varchar(200) — NOT NULL
- agent_phone — varchar(20) — NOT NULL
- agent_email — varchar(500) — NOT NULL — UNIQUE
- agent_pw — varchar(100) — NOT NULL
- agent_type — varchar(100) — NOT NULL — CHECK (agent_type IN ('agent', 'Operator'))
- agent_ip — varchar(45) — NOT NULL
- created_by — varchar(100) — NOT NULL
- join_date — datetime — NOT NULL
- last_login — datetime — NOT NULL
- updated_at — dateime — NOT NULL
- agent_status — char(8) — NOT NULL — CHECK (agent_status IN ('정상', '정지'))
archive
- archive_id — int — Primary key — NOT NULL — auto_increment
- notice_title (archive_title) — varchar(300) — NOT NULL
- author_name — varchar(200) — NOT NULL
- created_date — datetime — NOT NULL
- notice_content (archive_content) — varchar(2000) — NOT NULL
- file_path — VARCHAR(300) — NOT NULL
- views — int — NOT NULL
company_info (client_info)
- company_id — int — Primary key — NOT NULL — auto_increment
- company_name — varchar(200) — NOT NULL
- company_address — varchar(300) — NOT NULL
- industry_type — varchar(100) — NOT NULL
- manager_name — varchar(100) — NOT NULL
- manager_position — varchar(100) — NOT NULL
- manager_department — varchar(100) — NOT NULL
- manager_email — varchar(500) — NOT NULL
- manager_phone — varchar(20) — NOT NULL
notice
- notice_id — int — Primary key — NOT NULL — auto_increment
- notice_title — varchar(300) — NOT NULL
- author_name — varchar(200) — NOT NULL
- created_date — datetime — NOT NULL
- notice_content — varchar(2000) — NOT NULL
- top_fix — char(1) — NOT NULL — CHECK (top_fix IN ('Y', 'N'))
- views — int — NOT NULL