악성메일
테이블 (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