meandbooks
Tables (11)
book
- BOOK_NO — varchar(8) — Primary key — NOT NULL
- BOOK_NM — varchar(100) — NOT NULL
- BOOK_DESC — varchar(3000) — NOT NULL
- BOOK_PRICE — mediumint — NOT NULL
- BOOK_STOCK — smallint — NOT NULL
- BOOK_IMG — varchar(1000)
- BOOK_PUB — varchar(60) — NOT NULL
- BOOK_AUTHOR — varchar(60) — NOT NULL
- BOOK_PUB_DATE — date — NOT NULL
- BOOK_ISBN — varchar(20)
- BOOK_PAGE — smallint
cart
- CART_NO — varchar(10) — Primary key — NOT NULL
- BOOK_NO — varchar(8) — Foreign key → book.BOOK_NO — NOT NULL
- MEM_NO — mediumint — Foreign key → member.MEM_NO — NOT NULL
- CART_QTY — smallint — NOT NULL
faq
- FAQ_NO — mediumint — Primary key — NOT NULL
- FAQ_CATE — char(1) — NOT NULL
- FAQ_TITLE — varchar(100) — NOT NULL
- FAQ_CONTENT — varchar(3000) — NOT NULL
member
- MEM_NO — mediumint — Primary key — NOT NULL
- MEM_UID — varchar(15) — NOT NULL
- MEM_PWD — varchar(20) — NOT NULL
- MEM_NM — varchar(15) — NOT NULL
- MEM_PHONENO — varchar(11) — NOT NULL
- MEM_ADDR1 — varchar(300) — NOT NULL
- MEM_ADDR2 — varchar(300) — NOT NULL
- MEM_ADDR3 — varchar(300) — NOT NULL
- MEM_EMAIL — varchar(50) — NOT NULL
- MEM_MILEAGE — mediumint
- IS_ADMIN — char(1)
- ACCESSIBLE — char(1)
no_mem_orders
- ORDERS_NO — varchar(10) — Primary key — NOT NULL
- BOOK_NO — varchar(8) — Foreign key → book.BOOK_NO — NOT NULL
- ORDERS_NM — varchar(15) — NOT NULL
- ORDERS_PHONENO — varchar(11) — NOT NULL
- ORDERS_ADDR1 — varchar(300) — NOT NULL
- ORDERS_ADDR2 — varchar(300) — NOT NULL
- ORDERS_ADDR3 — varchar(300) — NOT NULL
- ORDERS_DATE — datetime — NOT NULL
- ORDERS_QTY — smallint — NOT NULL
- ORDERS_STATUS — char(1)
notice
- NOTI_NO — mediumint — Primary key — NOT NULL
- NOTI_TITLE — varchar(100) — NOT NULL
- NOTI_CONTENT — varchar(3000) — NOT NULL
- NOTI_DATE — datetime — NOT NULL
orders
- ORDERS_NO — varchar(10) — Primary key — NOT NULL
- MEM_NO — mediumint — Foreign key → member.MEM_NO — NOT NULL
- BOOK_NO — varchar(8) — Foreign key → book.BOOK_NO — NOT NULL
- ORDERS_NM — varchar(15) — NOT NULL
- ORDERS_PHONENO — varchar(11) — NOT NULL
- ORDERS_ADDR1 — varchar(300) — NOT NULL
- ORDERS_ADDR2 — varchar(300) — NOT NULL
- ORDERS_ADDR3 — varchar(300) — NOT NULL
- ORDERS_DATE — datetime — NOT NULL
- ORDERS_QTY — smallint — NOT NULL
- ORDERS_STATUS — char(1)
qna_a
- A_NO — mediumint — Primary key — NOT NULL
- MEM_NO — mediumint — Foreign key → member.MEM_NO — NOT NULL
- Q_NO — mediumint — Foreign key → qna_q.Q_NO — NOT NULL
- A_CONTENT — varchar(3000) — NOT NULL
- A_DATE — datetime — NOT NULL
qna_q
- Q_NO — mediumint — Primary key — NOT NULL
- MEM_NO — mediumint — Foreign key → member.MEM_NO — NOT NULL
- Q_TITLE — varchar(100) — NOT NULL
- Q_CONTENT — varchar(3000) — NOT NULL
- Q_DATE — datetime — NOT NULL
- Q_PWD — varchar(20) — NOT NULL
- Q_CATE — char(1) — NOT NULL
- ACCESS_LEVEL — char(1) — NOT NULL
rev_cmt
- CMT_NO — mediumint — Primary key — NOT NULL
- REV_NO — mediumint — Foreign key → review.REV_NO — NOT NULL
- MEM_NO (MEM_NO2) — mediumint — Foreign key → review.MEM_NO — NOT NULL
- BOOK_NO (BOOK_NO2) — varchar(8) — Foreign key → review.BOOK_NO — NOT NULL
- MEM_NO — mediumint — NOT NULL
- CMT_CONTENT — varchar(1000) — NOT NULL
- CMT_DATE — datetime — NOT NULL
review
- REV_NO — mediumint — Primary key — NOT NULL
- MEM_NO — mediumint — Foreign key → member.MEM_NO — NOT NULL
- BOOK_NO — varchar(8) — Foreign key → book.BOOK_NO — NOT NULL
- REV_TITLE — varchar(100) — NOT NULL
- REV_CONTENT — varchar(3000) — NOT NULL
- REV_RATING — tinyint — NOT NULL
- REV_DATE — datetime — NOT NULL