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