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)