coder

Tables (8)

FILES

  • FILENO — NUMBER — Primary key — NOT NULL
  • ORIGINAL_FILE_NAME — VARCHAR2(260) — NOT NULL
  • FILE_SIZE — NUMBER — NOT NULL
  • STORED_FILE_NAME — VARCHAR2(40) — NOT NULL

ProjectBoard

  • Project_No — NUMBER — Primary key
  • Project_Name — varchar2(60) — NOT NULL
  • Project_Start — date — NOT NULL
  • Project_End — date — NOT NULL
  • Project_Member — number — NOT NULL
  • Project_Context — varchar2(3000) — NOT NULL

ProjectFiles

  • PF_No — NUMBER — Primary key
  • POF_Name — varchar2(260) — NOT NULL
  • PF_Size — number — NOT NULL
  • PSF_Name — varchar2(40) — NOT NULL

Project_Detail

  • PD_Board_No — NUMBER — Primary key — NOT NULL
  • PD_Title — VARCHAR2(30) — NOT NULL
  • PD_Context — VARCHAR2(300) — NOT NULL
  • PD_Date — date
  • PD_Writer — VARCHAR2(30) — NOT NULL
  • PD_Ing — VARCHAR2(21) — NOT NULL
  • PD_Import — VARCHAR2(6) — NOT NULL
  • PD_Start — date
  • PD_End — date
  • PD_Del_Gb — VARCHAR2(2) — NOT NULL

REPLY

  • COMNO — NUMBER — Primary key — NOT NULL
  • REPLY_DATE — DATE — NOT NULL
  • CONTEXT — VARCHAR2(3000) — NOT NULL
  • RECOMMAND_COUNT — NUMBER — NOT NULL
  • DEL_GB — VARCHAR2(2) — NOT NULL

application

  • application_email — varchar2(40) — NOT NULL
  • application_accept — varchar2(2) — NOT NULL

board

  • Board_No — NUMBER — Primary key — NOT NULL
  • Title — VARCHAR2(50) — NOT NULL
  • context — VARCHAR2(3000) — NOT NULL
  • Board_Date — date — NOT NULL
  • Identi_Type — VARCHAR2(2) — NOT NULL
  • recommend_count — NUMBER
  • read_count — number
  • reply_count — number
  • report_cunt — NUMBER
  • del_gb — VARCHAR2(2)

user

  • user_No — number — Primary key — NOT NULL
  • email — varchar2(40) — Primary key — NOT NULL
  • nick_name — varchar2(30) — NOT NULL
  • password — varchar2(12) — NOT NULL
  • report_count — number — NOT NULL
  • del_gb — varchar2(2) — NOT NULL
  • user_stop — varchar2(2) — NOT NULL
  • active_Score — number — NOT NULL
  • user_date — date — NOT NULL
  • admin — varchar2(2) — NOT NULL