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