E

Tables (17)

Copy Of Untitled (CopyOfSelectCategory)

  • Key (selectcategory_no) — Primary key — NOT NULL
  • Key (bigCategory_no) — Foreign key → Untitled.Key — NOT NULL
  • Key (smallCategory_no) — Foreign key → Untitled2.Key — NOT NULL

Untitled (Board(게시판))

  • Key (Board_no) — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (image_no) — Foreign key → Untitled.Key — NOT NULL
  • Field (board_content)
  • Field2 (board_readcount)
  • Field (board_writedate)

Untitled

    Untitled (SelectCategory)

    • Key (selectcategory_no) — Primary key — NOT NULL
    • Key (bigCategory_no) — Foreign key → Untitled.Key — NOT NULL
    • Key (smallCategory_no) — Foreign key → Untitled2.Key — NOT NULL

    Untitled (Date(월화수목금토일))

    • Key (date_no) — Primary key — NOT NULL
    • Field (date)

    Untitled (Academy(to-do list에 학원 입력 부분))

    • Key (academy_no) — Primary key — NOT NULL
    • Field (academy_name)
    • Field2 (academy_address)
    • Field3 (ratings)

    Untitled (PublicOrNot(위시리스트공개비공개))

    • Key (pon_no) — Primary key — NOT NULL
    • Field (public_or_not) — String

    Untitled (BoardImage(게시판 이미지 삽입용))

    • Key (image_no) — Primary key — NOT NULL
    • Field (image_link)
    • Field2 (image_originalfilename)

    Untitled (BoardLike(자유게시판 좋아요))

    • Key (boardLike_no) — Primary key — NOT NULL
    • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
    • Key (Board_no) — Foreign key → Untitled.Key — NOT NULL
    • Field (like_date)

    Untitled (BigCategory(대분류))

    • Key (bigCategory_no) — Primary key — NOT NULL
    • Field (bigCategory_name)

    Untitled (WishList(위시리스트))

    • Key (wishList_no) — Primary key — NOT NULL
    • Key (pon_no) — ?? — Foreign key → Untitled.Key — NOT NULL
    • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
    • Key (toDoList_no) — Foreign key → Untitled.Key — NOT NULL
    • Key (selectcategory_no) — Foreign key → Copy Of Untitled.Key — NOT NULL
    • Field (theme)
    • Field (accessCommentation)
    • Field (self_review)
    • Field (winning_prize)
    • Field (wishlist_image(??))
    • Field (공개비공개)

    Untitled (To-Do List)

    • Key (toDoList_no) — Primary key — NOT NULL
    • Key (academy_no) — Foreign key → Untitled.Key — NOT NULL
    • Field2 (doWhat)

    Untitled (Ranking(랭킹 페이지 - 친구끼리만 노출되게))

    • Key (rank_no) — Primary key — NOT NULL
    • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
    • Field (ranking_members)
    • Field2 (?)
    • Field3 (??)

    Untitled (Member(회원))

    • Key (member_no) — NUMBER — Primary key — NOT NULL
    • Key (selectcategory_no) — Foreign key → Untitled.Key — NOT NULL
    • Field (member_id)
    • Field2 (member_pw)
    • Field3 (member_name)
    • Field4 (member_phone)
    • Field6 (member_mail)

    Untitled2 (SmallCategory(소분류))

    • Key (smallCategory_no) — Primary key — NOT NULL
    • Field (smallCategory_name)

    Untitled2 (FriendOrNot(회원 간의 친구 여부 체크))

    • Key (friend_or_not_no) — Primary key — NOT NULL
    • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
    • Field (friend_member_no)

    Untitled2 (SelectDate(요일선택 부분)))

    • Key (selectdate_no) — Primary key — NOT NULL
    • Key (toDoList_no) — Foreign key → Untitled.Key — NOT NULL
    • Key (date_no) — Foreign key → Untitled.Key — NOT NULL