1조

테이블 (11)

Copy Of Untitled (BOARD)

  • Key (NO) — NUMBER — 기본 키 — NOT NULL
  • Field (WRITER_NO) — NUMBER
  • Field (TITLE) — VARCHAR(100)
  • Field (CONTENT) — VARCHAR(5000)
  • Field (HIT) — NUMBER
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTAMP
  • Field (DEL_YN) — VARCHAR(1)

Copy Of Untitled2 (가맹점)

  • Key (NO) — NUMBER — 기본 키 — NOT NULL
  • Field (가맹점명) — VARCHAR(100)
  • Field (가맹코드) — VARCHAR(20)
  • Field (대표명) — VARCHAR(20)
  • Field (사업자등록번호) — NUMBER
  • Field (PHONE) — NUMBER
  • Field (ADDRESS) — VARCHAR(100)
  • Field (종목) — VARCHAR(50)
  • Field (클라이언트랑 연결) — NUMBER
  • Field (사번이랑 연결) — NUMBER
  • Field (캘린더랑 연결) — NUMBER
  • Field (계약시작시점)
  • Field (계약종료시점)
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTAMP
  • Field (DEL_YN) — VARCHAR(1)

MEMBER

  • Key (NO) — NUMBER — 기본 키 — NOT NULL
  • Field (사번) — VARCHAR2(20)
  • Field (ID) — VARCHAR2(20)
  • Field (PWD) — VARCHAR2(20)
  • Field (NICK) — VARCHAR2(20)
  • Field (NAME) — VARCHAR2(20)
  • Field (PHONE) — NUMBER
  • Field (주민번호) — NUMBER
  • Field2 (ADDRESS) — VARCHAR2(100)
  • Field (EMAIL) — VARCHAR2(100)
  • Field (GENDER) — VARCHAR(1)
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTAMP
  • Field (DEL_YN) — VARCHAR(1)

Untitled (PROJECT)

  • Field (PRJ_KEY) — VARCHAR(20) — 기본 키
  • Field (PRJ_NAME) — VARCHAR(100)
  • Field (멤버랑 외래키) — NUMBER
  • Field (사번이랑 연결) — NUMBER
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTAMP
  • Field (DEL_YN) — VARCHAR(1)

Untitled (CALENDER)

  • Key (NO) — NUMBER — 기본 키 — NOT NULL
  • Field (TITLE) — VARCHAR(100)
  • Field (CONTENT) — VARCHAR(1000)
  • Field (시작일)
  • Field (종료일)
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTAMP
  • Field (DEL_YN) — VARCHAR(1)
  • Field (WRITER_NO) — NUMBER
  • Field (PRJ_NO) — NUMBER
  • Field (CMT_NO) — NUMBER
  • Field (고객이랑연동)

Untitled (MESSAGE)

  • Key (NO) — NUMBER — 기본 키 — NOT NULL
  • Field (SEND_NO) — NUMBER
  • Field (RE_NO)
  • Field (CONTENT) — VARCHAR(1000)
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (부서연결)

Untitled (COMMENT)

  • Key (NO) — NUMBER — 기본 키 — NOT NULL
  • Field (CONTENT) — VARCHAR(1000)
  • Field (WRITER_NO) — NUMBER
  • Field (PRJ_NO) — NUMBER
  • Field (CAL_NO) — NUMBER
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTAMP

Untitled (COMPANY)

  • Field (사번) — VARCHAR2(20) — 기본 키
  • Field (회사명) — VARCHAR2(100)
  • Field (회사코드) — VARCHAR2(20)
  • Field (부서명) — VARCHAR2(100)
  • Field (부서코드) — VARCHAR2(20)
  • Field (직위명) — VARCHAR2(100)
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTMAP
  • Field (DEL_YN) — VARCHAR(1)

Untitled (NOTICE)

  • Key (NO) — NUMBER — 기본 키 — NOT NULL
  • Field (WRITER_NO) — NUMBER
  • Field (TITLE) — VARCHAR(100)
  • Field (CONTENT) — VARCHAR(5000)
  • Field (HIT) — NUMBER
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTAMP
  • Field (DEL_YN) — VARCHAR(1)

Untitled (ISSUE)

  • Key (NO) — NUMBER — 기본 키 — NOT NULL
  • Field (TITLE) — VARCHAR(200)
  • Field (CONTENT) — VARCHAR(1000)
  • Field (WRITER_NO) — NUMBER
  • Field (플젝이랑 연결 no) — NUMBER
  • Field (이슈 유형) — VARCHAR(100)
  • Field (진행상태) — VARCHAR(20)
  • Field (우선순위) — VARCHAR(20)
  • Field (시작일)
  • Field (종료일)
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTAMP
  • Field (DEL_YN) — VARCHAR(1)
  • Field (캘린더 연동) — NUMBER

Untitled (거래처)

  • Key (NO) — NUMBER — 기본 키 — NOT NULL
  • Field (거래처명) — VARCHAR(100)
  • Field (거래처코드) — VARCHAR(20)
  • Field (대표명) — VARCHAR(20)
  • Field (사업자등록번호) — NUMBER
  • Field (PHONE) — NUMBER
  • Field (ADDRESS) — VARCHAR(100)
  • Field (종목) — VARCHAR(50)
  • Field (클라이언트랑 연결) — NUMBER
  • Field (사번이랑 연결) — NUMBER
  • Field (캘린더랑 연결) — NUMBER
  • Field (계약시작시점) — TIMESTAMP
  • Field (계약종료시점) — TIMESTAMP
  • Field (ENROLL_DATE) — TIMESTAMP
  • Field (MODIFY_DATE) — TIMESTAMP
  • Field (DEL_YN) — VARCHAR(1)