Moving Out
Tables (6)
CHATTING (Untitled5)
- chat_no (Key) — number — Primary key — NOT NULL
- msg (Field) — varchar2(1000)
- chat_date (Field2) — date
- emp_id (Key2) — number — Foreign key → EMPLOYEE.emp_id — NOT NULL
- user_id (아이디) — varchar2(20) — Foreign key → USER.user_id — NOT NULL
DOCUMENT (Untitled4)
- document_no (Key) — number — Primary key — NOT NULL
- team_cd (Field2) — char(2)
- document_date (Field3) — date
- content (Field4) — varchar2(1000)
- user_id (아이디) — varchar2(20) — Foreign key → USER.user_id — NOT NULL
- emp_id (Key2) — number — Foreign key → EMPLOYEE.emp_id — NOT NULL
EMPLOYEE (Untitled)
- emp_id (Key) — number — Primary key — NOT NULL
- emp_name (Field) — varchar2(50)
- profile (Field2) — varchar2(300)
- team_cd (Field3) — char(2)
- hire_date (Field4) — date
- emp_mail (Field5) — varchar2(30)
RESERVATION (Untitled2)
- reservation_id (Key) — number — Primary key — NOT NULL
- team_cd (Field2) — char(2)
- status (Field3) — varchar2(10)
- reservation_date (Field4) — date
- user_id (아이디) — varchar2(20) — Foreign key → USER.user_id — NOT NULL
RESERVATION_MAIL (Untitled3)
- mail_no (Key) — number — Primary key — NOT NULL
- reservation_id (Field2) — number
- send_date (Field3) — date
- send_mail (Field4) — varchar2(1000)
- reservation_id (Key2) — number — Foreign key → RESERVATION.reservation_id — NOT NULL
USER (사용자)
- user_id (아이디) — varchar2(20) — Primary key — NOT NULL
- name (Field) — varchar2(20)
- address (Field2) — varchar2(30)
- email (Field3) — varchar2(30)
- phone (Field4) — varchar2(25)
- password (Field5) — varchar2(25)