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 (찐비번)