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