F.L_Project

Tables (10)

Answer (댓글)

  • answerNum (답변Id) — Not Null — Primary key — NOT NULL
  • boardId (게시판번호) — Not Null — Foreign key → Board.boardId — NOT NULL
  • userId (아이디2) — Not Null — Foreign key → UserData.userId — NOT NULL
  • content (내용)
  • created (댓글생성일) — Not Null
  • fix_created (댓글수정일) — Not Null

BackupItem (상품백업)

  • seq_No (책번호) — Not Null — Primary key — NOT NULL
  • isbn_thirteen_no (ISBN번호) — Not Null
  • title_Nm (책이름) — Not Null
  • authr_Nm (저자명) — Not Null
  • publisher_Nm (출판사) — Not Null
  • prc_Value (가격) — Not Null
  • image_Url (상품설명) — Not Null
  • KDC_Nm (카테고리) — Not Null
  • publict_de (출판일자) — Not Null
  • sal_Count (판매량)

BagItem (장바구니)

  • bagId (장바구니키) — Not Null — Primary key — NOT NULL
  • userId (아이디) — Not Null — Foreign key → UserData.userId — NOT NULL
  • seq_No (상품아이디) — Not Null — Foreign key → BookItem.seq_No — NOT NULL

Board (게시판)

  • boardId (게시판번호) — Not Null — Primary key — NOT NULL
  • userId (아이디) — Not Null — Foreign key → UserData.userId — NOT NULL
  • Subject (제목) — Not Null
  • Pwd (게시판비밀번호)
  • Content (내용)
  • hitCount (조회수) — Not Null
  • created (글생성일) — Not Null
  • fix_created (글수정일) — Not Null

BookItem (상품정보)

  • seq_No (책번호) — Not Null — Primary key — NOT NULL
  • isbn_thirteen_no (ISBN번호) — Not Null
  • title_Nm (책이름) — Not Null
  • authr_Nm (저자명) — Not Null
  • publisher_Nm (출판사) — Not Null
  • prc_Value (가격) — Not Null
  • image_Url (상품설명) — Not Null
  • KDC_Nm (카테고리) — Not Null
  • publict_de (출판일자) — Not Null
  • sal_Count (판매량)

Event_Board (이벤트게시판)

  • boardId (게시판번호) — Not Null — Primary key — NOT NULL
  • userId (아이디) — Not Null — Foreign key → UserData.userId — NOT NULL
  • Pwd (비밀번호) — Not Null
  • cno (카테고리번호) — Not Null
  • subject (제목) — Not Null
  • content (내용) — Not Null
  • Image_Url (이미지링크)
  • ipAddr (ip주소)
  • created (글 생성일)
  • hitCount (조회수)

Evt_Comment (Untitled)

  • commentId (Key) — Not Null — Primary key — NOT NULL
  • boardId (게시판번호) — Not Null — Foreign key → Event_Board.boardId — NOT NULL
  • userId (아이디) — Not Null — Foreign key → Event_Board.userId — NOT NULL
  • content (내용) — Not Null
  • created (생성일)
  • fix_created (수정일)

OrderBag (Untitled3)

  • orderId (결제번호) — Not Null — Primary key — NOT NULL
  • userId (아이디) — Not Null — Foreign key → UserData.userId — NOT NULL
  • seq_No (상품아이디) — Not Null — Foreign key → BookItem.seq_No — NOT NULL
  • orderDate (구매날자) — Not Null
  • orderGroup (결제묶음) — Not Null

Review (리뷰)

  • reviewId (리뷰아이디) — Not Null — Primary key — NOT NULL
  • seq_No (상품아이디) — Not Null — Foreign key → BookItem.seq_No — NOT NULL
  • userId (아이디2) — Not Null — Foreign key → UserData.userId — NOT NULL
  • content (내용) — Not Null
  • created (생성일)
  • fix_created (수정일)
  • ipAddr (ip주소)
  • reviewStar (별점)
  • Vip (vip)

UserData (유저정보)

  • userId (아이디) — Not Null — Primary key — NOT NULL
  • userPwd (비밀번호) — Not Null
  • userName (이름) — Not Null
  • userAddr (주소) — Not Null
  • userEmail (이메일)
  • userBirth (생년월일) — Not Null
  • userTel (전화번호) — Not Null
  • userVip (누적금)
  • userRole (어드민확인)
  • RealPwd (찐비번)