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