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