test

Tables (13)

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
  • MEM_NO — mediumint — Foreign key → member.MEM_NO
  • BOOK_NO — varchar(8) — Foreign key → book.BOOK_NO
  • 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_CONTNET — 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
  • 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)

no_mem_refund

  • REFUND_NO — varchar(10) — Primary key — NOT NULL
  • ORDERS_NO — varchar(8) — Foreign key → no_mem_orders.ORDERS_NO
  • REFUND_DESC — varchar(3000) — NOT NULL
  • REFUND_STATUS — char(1)

notice

  • NOTI_NO — mediumint — Primary key — NOT NULL
  • NOTI_TITLE — varchar(100) — NOT NULL
  • NOTI_CONTNET — 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
  • BOOK_NO — varchar(8) — Foreign key → book.BOOK_NO
  • 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
  • Q_NO — mediumint — Foreign key → qna_q.Q_NO
  • MEM_NO — mediumint — Foreign key → member.MEM_NO
  • 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
  • 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

refund

  • REFUND_NO — varchar(10) — Primary key — NOT NULL
  • ORDERS_NO — varchar(10) — Foreign key → orders.ORDERS_NO
  • REFUND_DESC — varchar(3000)
  • REFUND_STATUS — char(1)

rev_cmt

  • CMT_NO — mediumint — Primary key — NOT NULL
  • REV_NO — mediumint — Foreign key → review.REV_NO
  • MEM_NO — mediumint — Foreign key → member.MEM_NO
  • 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
  • BOOK_NO — varchar(8) — Foreign key → book.BOOK_NO
  • REV_TITLE — varchar(100) — NOT NULL
  • REV_CONTENT — varchar(3000) — NOT NULL
  • REV_RATING — tinyint — NOT NULL
  • REV_DATE — datetime — NOT NULL