notion_presentation
Tables (13)
CHATJOINER (채팅방 초대된 인원)
- CJ_NUM (CHATJOINER.NO) — NOT NULL — Primary key — NOT NULL
- ROOM_ID (채팅방) — NOT NULL — Foreign key → CHATROOM.ROOM_ID — NOT NULL
- M_NUM (MEMBER.NO) — NOT NULL — Foreign key → MEMBER.M_NUM — NOT NULL
CHATMESSAGE (공지사항 테이블)
- CM_NUM (CHATMSG.NO) — NOT NULL — Primary key — NOT NULL
- P_NUM (PROJECT.NO) — NOT NULL — Foreign key → PROJECT.P_NUM — NOT NULL
- M_NUM (MEMBER.NO) — NOT NULL — Foreign key → PROJECT.M_NUM — NOT NULL
- G_NUM (GUEST.NO) — NOT NULL — Foreign key → PROJECT.G_NUM — NOT NULL
- MESSAGE (채팅 내용) — NULL
- ATTFILE (첨부파일) — NULL
- TIME (채팅 시간) — NULL — NOT NULL
- CONTENT (상태메세지) — NULL
CHATMESSAGE2 (메세지 테이블)
- CM_NUM2 (CHATMSG2.NO) — NOT NULL — Primary key — NOT NULL
- M_NUM (MEMBER.NO) — NOT NULL — Foreign key → MEMBER.M_NUM — NOT NULL
- ROOM_ID (채팅방) — NOT NULL — Foreign key → CHATROOM.ROOM_ID — NOT NULL
- G_NUM (GUEST.NO) — NOT NULL — Foreign key → MEMBER.G_NUM — NOT NULL
- TIME (채팅 시간) — NULL
- MESSAGE (채팅 내용) — NOT NULL
- ATTFILE (첨부파일) — NULL
CHATROOM (채팅방 테이블)
- ROOM_ID (채팅방) — NOT NULL — Primary key — NOT NULL
- TIME (채팅 시간) — NULL
COMPANY (회사)
- C_NUM (COMPANY.NO) — NOT NULL — Primary key — NOT NULL
- G_NUM (GUEST.NO) — NOT NULL — Foreign key → GUEST.G_NUM — NOT NULL
- NAME (회사 이름) — NOT NULL
- REGDATE (회사 생성일) — NOT NULL
- SUBJECT (주제) — NOT NULL
DEPARTMENT (부서테이블)
- D_NUM (DEPARTMENT.NO) — NOT NULL — Primary key — NOT NULL
- C_NUM (COMPANY.NO) — NOT NULL — Foreign key → COMPANY.C_NUM — NOT NULL
- DEPART (부서명) — NULL
GUEST (회원 테이블)
- G_NUM (GUEST.NO) — NOT NULL — Primary key — NOT NULL
- PASSWORD (패스워드) — NULL
- G_NAME (이름) — NOT NULL
- EMAIL (이메일) — NOT NULL
- REGDATE (가입일) — NOT NULL
- AUTHKEY (인증키) — NULL
- AUTHSTATUS (인증상태) — NULL
MEMBER (멤버테이블)
- M_NUM (MEMBER.NO) — NOT NULL — Primary key — NOT NULL
- C_NUM (COMPANY.NO) — NOT NULL — Foreign key → COMPANY.C_NUM — NOT NULL
- G_NUM (GUEST.NO) — NOT NULL — Foreign key → COMPANY.G_NUM — NOT NULL
- AUTHORITY (권한) — NOT NULL
PROJECT (프로젝트 테이블)
- P_NUM (PROJECT.NO) — NOT NULL — Primary key — NOT NULL
- M_NUM (MEMBER.NO) — NOT NULL — Foreign key → MEMBER.M_NUM — NOT NULL
- C_NUM (COMPANY.NO) — NOT NULL — Foreign key → MEMBER.C_NUM — NOT NULL
- G_NUM (GUEST.NO) — NOT NULL — Foreign key → MEMBER.G_NUM — NOT NULL
- NAME (프로젝트 이름) — NOT NULL
- STARTDATE (프로젝트 시작 날짜) — NOT NULL
- ENDDATE (프로젝트 종료 날짜) — NOT NULL
- REGDATE (프로젝트 등록 날짜) — NOT NULL
- STATUS (프로젝트 상태) — NOT NULL
- SUBJECT (프로젝트 주제) — NOT NULL
- CONTENT (프로젝트 내용) — NOT NULL
PROJECTJOINER (프로젝트에 참가된 인원)
- J_NUM (KeyPROJECTJOINER.NO) — NOT NULL — Primary key — NOT NULL
- P_NUM (PROJECT.NO) — NOT NULL — Foreign key → PROJECT.P_NUM — NOT NULL
- M_NUM (MEMBER.NO) — NOT NULL — Foreign key → PROJECT.M_NUM — NOT NULL
ROLES (WLRRMQ)
- R_NUM (ROLE.NO) — NOT NULL — Primary key — NOT NULL
- C_NUM (COMPANY.NO) — NOT NULL — Foreign key → COMPANY.C_NUM — NOT NULL
- G_NUM (GUEST.NO) — NOT NULL — Foreign key → COMPANY.G_NUM — NOT NULL
- ROLE (직책) — NOT NULL
TODO (TODO 테이블)
- T_NUM (TODO.NO) — NOT NULL — Primary key — NOT NULL
- D_NUM (DEPARTMENT.NO) — NOT NULL — Foreign key → DEPARTMENT.D_NUM — NOT NULL
- P_NUM (PROJECT.NO) — NOT NULL — Foreign key → PROJECT.P_NUM — NOT NULL
- TITLE (제목) — NOT NULL
- TEXT (내용) — NULL
- ORDERDATE (지시일) — NOT NULL
- ENDDATE (완료일) — NOT NULL
- 지시자 (ORDER_M) — NOT NULL
- 수행자 (WORKER_M) — NOT NULL
- 상태 (PROGRESS) — NOT NULL
VERIFICATION (결재 테이블)
- V_NUM (VERIFICATION.NO) — NOT NULL — Primary key — NOT NULL
- T_NUM (TODO.NO) — NOT NULL — Foreign key → TODO.T_NUM — NOT NULL
- STATE (상태) — NULL
- FEEDBACK (피드백) — NULL
- CONFIRMDATE (결재일자) — NULL