WishList

Tables (12)

WL_Board (Untitled11)

  • Board_No (Key) — NUMBER — Primary key — NOT NULL
  • Member_No (Key2) — NUMBER — Foreign key → WL_Member.Member_No — NOT NULL
  • Board_Title (Field) — VARCHAR2
  • Board_Content (Field2) — VARCHAR2
  • Board_WriteDate (Field4) — DATE

WL_CSBoard (CopyOfUntitled11)

  • CSBoard_No (Key) — NUMBER — Primary key — NOT NULL
  • Member_No (Key2) — NUMBER — Foreign key → WL_Member.Member_No — NOT NULL
  • CSBoard_Title (Field) — VARCHAR2
  • CSBoard_Content (Field2) — VARCHAR2
  • CSBoard_ReadContent (Field3) — VARCHAR2
  • CSBoard_WriteDate (Field4) — DATE

WL_FriendsInvitation (Untitled7)

  • FriendsInvitation_No (Key) — NUMBER — Primary key — NOT NULL
  • Member_No (Key2) — NUMBER — Foreign key → WL_Member.Member_No — NOT NULL
  • FriendsInvitation_Name (Field) — VARCHAR2

WL_Friends_Member (Untitled10)

  • Friends_No (Key) — NUMBER — Primary key — NOT NULL
  • Friends_Id (Field) — VARCHAR2
  • Friends_Name (Field2) — VARCHAR2

WL_MatchClass (Untitled2)

  • MatchClass_No (Key) — NUMBER — Primary key — NOT NULL
  • MatchSubClass_No (Key2) — NUMBER — Foreign key → WL_MatchSubClass.MatchSubClass_No — NOT NULL
  • MatchClass_자기개발 (Field) — VARCHAR2
  • MatchClass_운동 (Field2) — VARCHAR2

WL_MatchSubClass (Untitled4)

  • MatchSubClass_No (Key) — NUMBER — Primary key — NOT NULL
  • MatchSubClass_공부 (Field) — VARCHAR2
  • MatchSubClass_헬스 (Field2) — VARCHAR2

WL_Member (Untitled)

  • Member_No (Key) — NUMBER — Primary key — NOT NULL
  • Member_Id (Field) — NUMBER
  • Member_Name (Field2) — VARCHAR2
  • Member_Phone (Field3) — VARCHAR2
  • Member_Email (Field4) — VARCHAR2
  • Member_Agreement (Field5) — VARCHAR2
  • Member_RegDate (Field6) — DATE
  • Member_Pw (Field7) — VARCHAR2

WL_MemberWish (Untitled3)

  • MemberWish_no (Key) — NUMBER — Primary key — NOT NULL
  • Member_No (Key2) — NUMBER — Foreign key → WL_Member.Member_No — NOT NULL
  • MatchClass_No (Key3) — NUMBER — Foreign key → WL_MatchClass.MatchClass_No — NOT NULL
  • MatchSubClass_No (Key22) — NUMBER — Foreign key → WL_MatchClass.MatchSubClass_No — NOT NULL

WL_Ranking (Untitled6)

  • Ranking_No (Key2) — NUMBER — Primary key — NOT NULL
  • FriendsInvitation_No (Key3) — NUMBER — Foreign key → WL_FriendsInvitation.FriendsInvitation_No — NOT NULL
  • SetWishList_No (Key) — NUMBER — Foreign key → WL_SetWishList.SetWishList_No — NOT NULL
  • Member_No (Key32) — NUMBER — Foreign key → WL_SetWishList.Member_No — NOT NULL
  • CSBoard_No (Key23) — NUMBER — Foreign key — NOT NULL
  • Ranking_SetPeople (Field) — VARCHAR2
  • Ranking_SetPrize (Field2) — VARCHAR2

WL_SetTodoList (Untitled8)

  • SetTodoList_No (Key) — Number — Primary key — NOT NULL
  • SetWishList_No (Key2) — NUMBER — Foreign key → WL_SetWishList.SetWishList_No — NOT NULL

WL_SetTodoListWeek (Untitled9)

  • SetTodoListWeek_No (Key) — NUMBER — Primary key — NOT NULL
  • SetTodoListWeek_Mon (Field) — VARCHAR2
  • SetTodoListWeek_Tue (Field2) — VARCHAR2
  • SetTodoListWeek_Wed (Field3) — VARCHAR2
  • SetTodoListWeek_Thur (Field4) — VARCHAR2
  • SetTodoListWeek_Fri (Field5) — VARCHAR2
  • SetTodoListWeek_Sat (Field6) — VARCHAR2
  • SetTodoListWeek_Sun (Field7) — VARCHAAR2

WL_SetWishList (Untitled5)

  • SetWishList_No (Key) — NUMBER — Primary key — NOT NULL
  • MemberWish_no (Key2) — NUMBER — Foreign key → WL_MemberWish.MemberWish_no — NOT NULL
  • Member_No (Key3) — NUMBER — Foreign key → WL_Member.Member_No — NOT NULL
  • SetWishList_Title (Field) — VARCHAR2
  • SetWishList_ProvideAuth (Field2) — VARCHAR2
  • SetWishList_ReplyAuth (Field3) — VARCHAR2