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)