bizONE

테이블 (3)

참여자(JOIN) (join)

  • joinSeq (PK) — INTEGER — 기본 키 — NOT NULL
  • resSeq (FK1) — INTEGER — 외래 키 → 회의예약(RES).resSeq — NOT NULL
  • userSeq (FK) — INTEGER — 외래 키 → 회원(USER).userSeq — NOT NULL

회원(USER) (user)

  • userSeq (PK) — INTEGER — 기본 키 — NOT NULL
  • userAdmin (Field) — BOOLEAN — NOT NULL
  • userName (Field2) — VARCHAR2(100) — NOT NULL
  • userDept (Field3) — VARCHAR2(100) — NOT NULL
  • userPos (Field4) — VARCHAR2(100) — NOT NULL
  • userEmail (Field5) — VARCHAR2(100) — NOT NULL
  • userPhone (Field6) — VARCHAR2(100) — NOT NULL

회의예약(RES) (res)

  • resSeq (PK) — INTEGER — 기본 키 — NOT NULL
  • resRoom (Field) — VARCHAR2(100) — NOT NULL
  • resDate (Field1) — DATE() — NOT NULL
  • resHost (Field2) — VARCHAR2(100)
  • resMemo (Field3) — VARCHAR2(1000) — NOT NULL
  • resStart (Field4) — VARCHAR2(100)
  • resEnd (Field5) — VARCHAR2(100)
  • resStartIndex (Field6) — INTEGER
  • resEndIndex (Field7) — INTEGER