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