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