리즘소프트
테이블 (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