ProjectManagement
Tables (8)
Untitled (tb_project)
- Key (pro_seq) — number — Primary key — NOT NULL
- Field2 (pro_title) — varchar(300) — NOT NULL
- Field3 (pro_contents) — varchar(60) — NOT NULL
- Field4 (pro_startDate) — Timestamp — NOT NULL
- Field (pro_endDate) — Timestamp — NOT NULL
Untitled (tb_message)
- Key (msg__seq) — number — Primary key — NOT NULL
- Field2 (msg__receiver) — varchar2(100) — NOT NULL
- Field3 (msg__time) — Timestamp — NOT NULL — default sysdate
- Field4 (msg__contents) — varchar2(3000) — NOT NULL
- Field5 (msg__read) — char(1) — NOT NULL — Y,N
- Key (msg_sender) — varchar(100) — Foreign key → member.Key — NOT NULL
Untitled (viewcount)
- Field4 (view_date) — NOT NULL
Untitled2 (tb_project_task)
- Key (pt_seq) — number — Primary key — NOT NULL
- Field (pt_writer) — varchar(100) — NOT NULL
- Field (pt_priority) — varchar(1 — NOT NULL — check(pt_priority in('H', 'M', 'L')) ))
- Field2 (pt_title) — varchar(300) — NOT NULL
- Field3 (pt_contents) — varchar(1000) — NOT NULL
- Field2 (pt_startDate) — Timestamp — NOT NULL
- Field (pt_endDate) — Timestamp — NOT NULL
- Key (pro_seq) — number — Foreign key → Untitled.Key — NOT NULL
Untitled2 (tb_file)
- Key (f_seq) — number — Primary key — NOT NULL
- Field (file_name) — varchar(300) — NOT NULL
- Field (original_file_name) — varchar(300) — NOT NULL
- Field4 (f_writeDate) — Timestamp — NOT NULL
- Field3 (f_writer) — varchar(100) — NOT NULL
- Field (f_downloadCnt) — number — NOT NULL
- Key (pro_seq) — number — Foreign key → Untitled.Key — NOT NULL
Untitled3 (tb_blackList)
- Field2 (bl_name) — varchar(100) — NOT NULL
- Field3 (bl_reason) — varchar(300)
- Key (bl_email) — varchar(100) — Foreign key → member.Key — NOT NULL
Untitled3 (tb_project_member)
- Key (pm_seq) — number — Primary key — NOT NULL
- mb_dfd (pm_check) — varchar(1) — NOT NULL — check('H','M')
- Key (pm_nickname) — varchar(100) — Foreign key → member.Key — NOT NULL
- Field (pm_name) — varchar(100) — NOT NULL
- Field (pm_email) — varchar(100) — NOT NULL
- Key (pro_seq) — number — Foreign key → Untitled.Key — NOT NULL
- Field (pm_img) — varchar(300) — NOT NULL
member (tb_member)
- Key (mb_email) — varchar(100) — Primary key — NOT NULL
- Field2 (mb_pw) — varchar(128) — NOT NULL
- Field (mb_img) — varchar(100) — NOT NULL
- Field4 (mb_nickname) — varchar(100) — NOT NULL
- Field3 (mb_name) — varchar(100) — NOT NULL
- Field (mb_group) — varchar(100)
- Field (mb_phone) — varchar(11) — NOT NULL
- Field (mb_check) — varchar(1) — NOT NULL — A,M