jaProject
Tables (42)
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled4 (FreeBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (freeboard_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (comment_writedate) — DATE — NOT NULL
- Field (member_nick) — VARCHAR2(100)
- Field (member_pw) — VARCHAR2(100) — NOT NULL
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Untitled5 (FreeBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (freeboard_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled4 (Wanted_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (wanted_no) — NUMBER — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (comment_writedate) — DATE — NOT NULL
- Field (member_nick) — VARCHAR2(100)
- Field (member_pw) — VARCHAR2(100) — NOT NULL
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled5 (Wanted_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (wanted_no) — NUMBER — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Copy Of Copy Of Copy Of Untitled4 (ReportBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (reportboard_no) — NUMBER — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (comment_writedate) — DATE — NOT NULL
- Field (member_nick) — VARCHAR2(100)
- Field (member_pw) — VARCHAR2(100) — NOT NULL
Copy Of Copy Of Copy Of Copy Of Untitled5 (ReportBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (reportboard_no) — NUMBER — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Copy Of Copy Of Copy Of Untitled6 (InformationBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (informationboard_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Copy Of Copy Of Untitled2 (DonateTalent)
- Key (donatetalent_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Copy Of Copy Of Untitled3 (DonateTalent_Recommend)
- Key (recommend_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (donatetalent_no) — NUMBER — Foreign key → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (recommend_date) — DATE — NOT NULL
Copy Of Copy Of Copy Of Untitled4 (DonateTalent_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (donatetalent_no) — NUMBER — Foreign key → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (comment_writedate) — DATE — NOT NULL
Copy Of Copy Of Copy Of Untitled5 (DonateTalent_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (donatetalent_no) — NUMBER — Foreign key → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Copy Of Copy Of Untitled6 (NoticeBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (noticeboard_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Copy Of Untitled (ReportBoard)
- Key (reportboard_no) — NUMBER — Primary key — NOT NULL
- Key (species_no) — NUMBER — Foreign key → Untitled.Key
- Key (location_no) — NUMBER — Foreign key → Untitled.Key
- Field (nick) — VARCHAR2(50)
- Field2 (pw) — VARCHAR2(50) — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (phoneNum) — VARCHAR2(40)
- Field (address) — VARCHAR2(100)
- Field (petGender) — VARCHAR2(4)
- Field (writeDate) — DATE — NOT NULL
- Field (recommend) — NUMBER — NOT NULL
Copy Of Copy Of Untitled2 (TipBoard)
- Key (tipboard_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Copy Of Untitled22 (ReviewBoard)
- Key (reviewboard_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Copy Of Untitled3 (TipBoard_Recommend)
- Key (recommend_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (tipboard_no) — NUMBER — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (recommend_date) — DATE — NOT NULL
Copy Of Copy Of Untitled4 (TipBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (tipboard_no) — NUMBER — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (comment_writedate) — DATE — NOT NULL
Copy Of Copy Of Untitled5 (TipBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (tipboard_no) — NUMBER — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Copy Of Untitled6 (PRBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (prboard_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Copy Of Untitled7 (PRBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (prboard_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (comment_writedate) — DATE — NOT NULL
Copy Of Copy Of Untitled8 (PRBoard_Recommend)
- Key (recommend_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (prboard_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (recommend_date) — DATE — NOT NULL
Copy Of Untitled (Wanted)
- Key (wanted_no) — NUMBER — Primary key — NOT NULL
- Key (species_no) — NUMBER — Foreign key → Untitled.Key
- Key (location_no) — NUMBER — Foreign key → Untitled.Key
- Field (nick) — VARCHAR2(50)
- Field2 (pw) — VARCHAR2(50) — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (phoneNum) — VARCHAR(40)
- Field (address) — VARCHAR2(100)
- Field (petGender) — VARCHAR2(4)
- Field (writeDate) — DATE — NOT NULL
- Field (recommend) — NUMBER — NOT NULL
Copy Of Untitled2 (CommemorateBoard)
- Key (commemorateboard_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Untitled3 (FundingBoard_Recommend)
- Key (recommend_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (funding_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (recommend_date) — DATE — NOT NULL
Copy Of Untitled4 (FundingBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (funding_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (comment_writedate) — DATE — NOT NULL
Copy Of Untitled5 (FundingBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (funding_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Untitled6 (CommemorateBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (commemorateboard_no) — NUMBER — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Copy Of Untitled7 (CommemorateBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (commemorateboard_no) — NUMBER — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (comment_writedate) — DATE — NOT NULL
Copy Of Untitled8 (CommemorateBoard_Recommend)
- Key (recommend_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (commemorateboard_no) — NUMBER — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Field (recommend_date) — DATE — NOT NULL
Member
- Key (member_no) — NUMBER — Primary key — NOT NULL
- Field (id) — VARCHAR2(50) — NOT NULL
- Field2 (pw) — VARCHAR2(50) — NOT NULL
- Field (nick) — VARCHAR2(50) — NOT NULL
- Field (name) — VARCHAR2(30) — NOT NULL
- Field (birth) — DATE — NOT NULL
- Field (gender) — VARCHAR2(4) — NOT NULL
- Field (phone) — VARCAHR2(50) — NOT NULL
- Field (email) — VARCHAR2(50) — NOT NULL
- Field (address) — VARCAHR2(100) — NOT NULL
- Field (auth) — VARCHAR2(4) — NOT NULL
- Field (petName) — VARCAHR2(50)
- Field (manner) — NUMBER
- Field (coin) — NUMBER
- Field (joinDate) — DATE — NOT NULL
Untitled (ReviewBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (reviewboard_no) — NUMBER — Foreign key → Copy Of Copy Of Untitled22.Key — NOT NULL
- Field (imageboard_url) — VARCHAR2(300) — NOT NULL
- Field (imageboard_ori) — VARCHAR2(300) — NOT NULL
Untitled (ReviewBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (reviewboard_no) — NUMBER — Foreign key → Copy Of Copy Of Untitled22.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (comment_writedate) — DATE — NOT NULL
Untitled (ReviewBoard_Recommend)
- Key (recommend_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (reviewboard_no) — NUMBER — Foreign key → Copy Of Copy Of Untitled22.Key — NOT NULL
- Field (recommend_date) — DATE — NOT NULL
Untitled (FundingMember)
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (funding_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (amount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Untitled (FundingBoard)
- Key (funding_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (BeginDate) — DATE — NOT NULL
- Field (EndDate) — DATE — NOT NULL
- Field (targetMoney) — NUMBER — NOT NULL
- Field2 (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
- Field (FundingComplete) — VARCHAR2(4) — NOT NULL
Untitled (PRBoard)
- Key (prboard_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Untitled (PetSpecies_category)
- Key (species_no) — NUMBER — Primary key — NOT NULL
- Field (species) — VARCHAR2(100) — NOT NULL
Untitled (Location_category)
- Key (location_no) — NUMBER — Primary key — NOT NULL
- Field (location) — VARCHAR2(100) — NOT NULL
Untitled (InformationBoard)
- Key (informationboard_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Untitled (NoticeBoard)
- Key (noticeboard_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title) — VARCHAR(400) — NOT NULL
- Field (content) — VARCHAR(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Untitled (MailAuth)
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (mail_key) — VARCHAR(100) — NOT NULL
- Field (mail_complete) — VARCHAR(4) — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Untitled (FreeBoard)
- Key (freeboard_no) — NUMBER — Primary key — NOT NULL
- Field (nick) — VARCHAR2(50)
- Field2 (pw) — VARCHAR2(50) — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
- Field (recommend) — NUMBER — NOT NULL