회의록
테이블 (5)
ATTACH_FILE (파일관리 테이블)
- FILECODE (Key) — VARCHAR(10) — 기본 키 — NOT NULL
- FILE_LOCATION (Field) — VARCHAR(100)
- FILE_NAME (Field2) — VARCHAR(100)
- FILE_EXTENTION (Field3) — VARCHAR(10)
- FILE_FULLNAME (Field4) — VARCHAR(100)
- CREATE_DATE (Field5) — VARCHAR(15)
- CREATE_USER (Field6) — VARCHAR(15)
- MDO_DATE (Field7) — VARCHAR(15)
- MOD_USER (Field8) — VARCHAR(15)
MITUTES (회의록)
- MITUTES_ID (Key) — varchar(10) — 기본 키 — NOT NULL
- MINUTES_AUTH (Field4) — VARCHAR(3)
- MITUTES_OPEN (Field18) — varchar(1)
- MINUTES_PASSWORD (Field17) — varchar(30)
- MITUTES_SUBJECT (Field) — varchar(100)
- MINUTES_DEPT (Field15) — VARCHAR(5)
- MINUTES_USER (Field16) — VARCHAR(15)
- MITUTES_PERSON (Field2) — number
- MITUTES_JOIN_ID (Field3) — varchar(300)
- MITUTES_DATE (Field5) — varchar(6)
- MITUTES_START_TIME (Field6) — VARCHAR(6)
- MITUTES_END_TIME (Field7) — varchar(6)
- MITUTES_PLACE (Field8) — varchar(100)
- MITUTES_CONTENTS (Field9) — varchar(3000)
- MITUTES_FILE (Field10) — varchar(100)
- CREATE_DATE (Field11) — varchar(15)
- CREATE_USER (Field12) — varchar(15)
- MOD_DATE (Field13) — varchar(15)
- MOD_USER (Field14) — varchar(15)
Untitled (인물 메인)
- man_id (Key2) — 기본 키 — NOT NULL
- company_id (Key) — 외래 키 → Untitled.company_id — NOT NULL
- Field
- Field2
- Field10
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9 — varchar
- Field11
- Field12
- Field13
- Field14
- Field15
Untitled (회사정보 테이블)
- company_id (Key) — 기본 키 — NOT NULL
- (Field)
- (Field2)
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
- Field9
- Field10
- Field11
membership (회원 테이블)
- id (Key) — varchar(15) — 기본 키 — NOT NULL
- password (Field) — varchar(30)
- user_name (Field2) — varchar(20)
- birth (Field3) — varchar(6)
- gender (Field4) — int
- email (Field5) — varchar(35)
- phone (Field6) — varchar(16)
- auth (Field7) — varchar(1)