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