악성메일

테이블 (3)

Email

  • emailIdx — number(20) — 기본 키 — NOT NULL
  • title — varchar2(50)
  • content — varchar2(500)
  • file — varchar2(100)

Train

  • trainIdx — number(20) — 기본 키 — NOT NULL
  • persual — number(10)
  • report — number(10)
  • link — number(10)
  • transmitDate — Date
  • departmentName — varchar2(50)
  • emailIdx — number(20) — 외래 키 → Email.emailIdx — NOT NULL
  • userIdx — number(20) — 외래 키 → User.userIdx — NOT NULL

User

  • userIdx — number(20) — 기본 키 — NOT NULL
  • userId — varchar2(20)
  • password — varchcr2(20)
  • repassword — varchar2(20)
  • userName — varchar2(20)
  • email — varchar2(50)
  • userType — number(10)
  • phone — number(20)
  • birthday — Date
  • retraining — boolean