회의록

테이블 (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)