리즘소프트

테이블 (6)

로그인로그 (Login_log)

  • log_no (PK) — Long — 기본 키 — NOT NULL
  • log_type (Field2) — varchar2(50)
  • status (Field6) — varchar2(100)
  • reg_date (Field7) — datetime
  • reg_id (Field9) — varchar2(500)
  • reg_ip (Field10) — varchar2(500)
  • login_id (Field) — varchar2(50)

제작문의 (Request)

  • rq_no (PK) — Long — 기본 키 — NOT NULL
  • file_no (PK2) — varchar2(500) — 외래 키 → 파일.file_no — NOT NULL
  • type (Field) — number
  • company_name (Field2) — varchar2(500)
  • phone_number (Field3) — varchar2(500)
  • email (Field4) — varchar2(500)
  • name (Field5) — varchar2(500)
  • mobile_number (Field6) — varchar2(500)
  • homepage (Field7) — varchar2(500)
  • site (Field8) — varchar2(500)
  • content (Field9) — varchar2(2000)
  • agree (Field10) — char(1)
  • reg_date (Field11) — datetime
  • reg_id (Field12) — varchar2(500)
  • reg_ip (Field13) — varchar2(500)
  • mod_date (Field14) — datetime
  • mod_id (Field15) — varchar2(500)
  • mod_ip (Field16) — varchar2(500)
  • del_yn (Field17) — char(1)
  • status (Field18) — varchar(10)
  • ratio (Field19) — Long

채용 (Recruit)

  • rc_no (PK) — Long — 기본 키 — NOT NULL
  • user_no (FK2) — Long — 외래 키 → 회원.user_no — NOT NULL
  • file_no (FK) — varchar2(500) — 외래 키 → 파일.file_no — NOT NULL
  • type (Field) — char(1)
  • name (Field2) — varchar2(50)
  • email (Field3) — varchar2(100)
  • contact (Field4) — varchar2(50)
  • start_date (Field5) — datetime
  • agree (Field6) — char(1)
  • reg_date (Field7) — datetime
  • reg_id (Field8) — varchar(50)
  • reg_ip (Field9) — varchar(255)
  • mod_date (Field10) — datetime
  • mod_id (Field11) — varchar(50)
  • mod_ip (Field12) — varchar2(255)
  • del_yn (Field13) — char(1)
  • status (Field14) — varchar(10)

파일 (File)

  • file_no (PK) — varchar2(500) — 기본 키 — NOT NULL
  • upload_path (Field2) — varchar2(500)
  • file_name (Field) — varchar2(500)
  • reg_date (Field4) — datetime
  • mod_date (Field5) — datetime
  • del_yn (Field3) — char(1)

포트폴리오 (Portfolio)

  • pf_no (PK) — Long — 기본 키 — NOT NULL
  • user_no (PK2) — Long — 외래 키 → 회원.user_no — NOT NULL
  • file_no (PK3) — varchar2(500) — 외래 키 → 파일.file_no — NOT NULL
  • title (Field) — varchar2(500)
  • content (Field2) — varchar2(500)
  • reg_date (Field3) — datetime
  • mod_date (Field4) — datetime
  • reg_id (Field5) — varchar2(500)
  • reg_ip (Field6) — varchar2(500)
  • mod_id (Field7) — varchar2(500)
  • mod_ip (Field8) — varchar2(500)
  • del_yn (Field9) — char(1)
  • status (Field10) — varchar(10)

회원 (User)

  • user_no (PK) — Long — 기본 키 — NOT NULL
  • user_id (Field) — varchar2(50)
  • password (Field2) — varchar2(50)
  • del_yn (Field5) — varchar2(50)
  • user_name (Field6) — varchar2(100)
  • role (Field7) — number
  • reg_id (Field9) — varchar2(500)
  • reg_ip (Field10) — varchar2(500)
  • mod_id (Field11) — varchar2(500)
  • mod_ip (Field12) — varchar2(500)
  • mod_date (Field4) — datetime
  • reg_date (Field3) — datetime