team3

Tables (7)

booklist (도서목록)

  • book_idx (Key2) — smallint — Primary key — NOT NULL
  • book_name (Field2) — varchar
  • price (Field3) — varchar
  • category (Field4) — varchar
  • rating (Field5) — varchar
  • date (Field6) — varchar
  • person_name (Field7) — varchar
  • publisher (Field8) — varchar
  • img (Field9) — varchar
  • description (Field10) — text
  • varchar (Field11) — varchar

bookout (대출)

  • boid (Key) — int — Primary key — NOT NULL
  • memidx (Key2) — int — Foreign key → team3_member.memidx — NOT NULL
  • book_idx (Key22) — smallint — Foreign key → booklist.book_idx — NOT NULL
  • regdate (Field3) — date
  • returns (Field4) — varchar

notices (공지사항)

  • notice_id (Key) — int — Primary key — NOT NULL
  • notice_title (Field) — varchar
  • notice_content (Field2) — text
  • notice_author (Field3) — varchar
  • notice_created (Field4) — datetime
  • notice_views (Field5) — int
  • notice_attachments (Field6) — varchar

outcart (북마크)

  • oid (Key) — int — Primary key — NOT NULL
  • memidx (Key2) — int — Foreign key → team3_member.memidx — NOT NULL
  • book_idx (Key22) — smallint — Foreign key → booklist.book_idx — NOT NULL
  • regdate (Field3) — date
  • book_status (Field) — varchar

team3_aibbs (빅데이터)

  • brdidx (Key) — int — Primary key — NOT NULL
  • memid (Field3) — varchar — Primary key
  • boardpwd (Field2) — varchar
  • category (Field4) — varchar
  • subtitle (Field5) — varchar
  • contents (Field6) — varchar
  • attach01 (Field7) — varchar
  • attach02 (Field8) — varchar
  • attach03 (Field9) — varchar
  • attach04 (Field10) — varchar
  • codefile (Field11) — varchar
  • readcnt (Field12) — int
  • groupnum (Field13) — int
  • ordernum (Field14) — int
  • depthcnt (Field15) — tinyint
  • likes (Field16) — smallint
  • hates (Field17) — smallint
  • regdate (Field18) — datetime
  • updated (Field19) — datetime

team3_book_review (도서리뷰)

  • reviewidx (Key) — int — Primary key — NOT NULL
  • book_idx (Key22) — smallint — Foreign key → booklist.book_idx — NOT NULL
  • memid (Field3) — varchar
  • review_title (Field4) — varchar
  • review_body (Field5) — varchar
  • review_cnt (Field6) — int
  • review_regdate (Field7) — datetime
  • review_updated (Field8) — datetime

team3_member (회원)

  • memidx (Key) — int — Primary key — NOT NULL
  • memid (Field) — varchar
  • mempwd (Field2) — varchar
  • memname (Field3) — varchar
  • gender (Field4) — varchar
  • birth (Field5) — date
  • mobile (Field6) — varchar
  • email (Field7) — varchar
  • addr01 (Field8) — varchar
  • addr02 (Field9) — varchar
  • remark (Field10) — text
  • mpoint (Field11) — int
  • logcnt (Field12) — int
  • dropout (Field13) — tinyint
  • regdate (Field14) — datetimed
  • updated (Field15) — datetime