HE_Co_Working_0809
Tables (31)
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled4 (HE_LostdogBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (lostdogboard_no) — NUMBER — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled5 (HE_LostdogBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (lostdogboard_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 (HE_FinddogBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (finddogboard_no) — NUMBER — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Copy Of Copy Of Copy Of Untitled5 (HE_FinddogBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (finddogboard_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 (HE_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 (HE_TalentBoard)
- Key (talentboard_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 Untitled4 (HE_TalentBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (talentboard_no) — NUMBER — Foreign key → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Copy Of Copy Of Untitled5 (HE_TalentBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (talentboard_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 (HE_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 (HE_FinddogBoard(주운사람이올린글))
- Key (finddogboard_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (species_no) — NUMBER — Foreign key → Untitled.Key
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (finidPlace) — VARCHAR2(4000)
- Field (latitude) — NUMBER — NOT NULL
- Field (longtitude) — NUMBER — NOT NULL
- Field (findDate) — DATE — NOT NULL
- Field (petGender) — VARCHAR2(4)
- Field (petName) — VARCHAR2(400)
- Field (petAge) — NUMBER
- Field (contact) — VARCHAR2(4000)
- Field (status) — VARCHAR(10) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Copy Of Untitled22 (HE_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 Untitled6 (HE_ShineBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (shineboard_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 (HE_ShineBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (shineboard_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Copy Of Untitled8 (HE_ShineBoard_Like)
- Key (like_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (shineboard_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Untitled (HE_LostdogBoard(주인이올린글))
- Key (lostdogboard_no) — NUMBER — Primary key — NOT NULL
- Key (species_no) — NUMBER — Foreign key → Untitled.Key
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title) — VARCHAR2(400) — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (lostPlace) — VARCHAR2(4000)
- Field (latitude) — NUMBER — NOT NULL
- Field (longtitude) — NUMBER — NOT NULL
- Field (lostDate) — DATE — NOT NULL
- Field (petGender) — VARCHAR2(4)
- Field (petName) — VARCHAR2(100)
- Field (petAge) — NUMBER
- Field (contact) — VARCHAR(4000)
- Field (status) — VARCHAR2(10) — NOT NULL
- Field (readcount) — NUMBER — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Untitled2 (HE_RememberBoard)
- Key (rememberboard_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 Untitled6 (HE_RememberBoard_ImageBoard)
- Key (imageboard_no) — NUMBER — Primary key — NOT NULL
- Key (rememberboard_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 (HE_RememberBoard_Comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (rememberboard_no) — NUMBER — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Field (comment_content) — VARCHAR2(4000) — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Copy Of Untitled8 (HE_RememberBoard_Like)
- Key (like_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (rememberboard_no) — NUMBER — Foreign key → Copy Of Untitled2.Key — NOT NULL
- Field (writeDate) — DATE — NOT NULL
Member (HE_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 (postCode) — VARCHAR2(50) — NOT NULL
- Field (address) — VARCAHR2(100) — NOT NULL
- Field (petName) — VARCAHR2(50)
- Field (coin) — NUMBER
- Field (joinDate) — DATE — NOT NULL
Untitled (HE_NoteBox_FriendList)
- Key (friendlist_no) — NUMBER — Primary key — NOT NULL
- Key (grouplist_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field2 (friend_no) — NUMBER — NOT NULL
Untitled (HE_NoteBox_GroupLit)
- Key (grouplist_no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (group_name) — VARCHAR2(400) — NOT NULL
Untitled (HE_notebox_category)
- Key (notebox_category_no) — NUMBER — Primary key — NOT NULL
- Field (category_name) — VARCHAR2(4000) — NOT NULL
Untitled (HE_NoteBox)
- Key (notebox_no) — NUMBER — Primary key — NOT NULL
- Key (notebox_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (friend_no) — NUMBER — NOT NULL
- Field (content) — VARCHAR2(4000) — NOT NULL
- Field (writeDate) — DATE — NOT NULL
- Field (readDate) — DATE
Untitled (HE_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 (HE_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 (writeDate) — DATE — NOT NULL
Untitled (HE_ShineBoard)
- Key (shineboard_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 (HE_Species_category)
- Key (species_no) — NUMBER — Primary key — NOT NULL
- Field (species) — VARCHAR2(4000) — NOT NULL
Untitled (HE_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 (HE_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 (HE_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