flower

Tables (7)

TB_AMIN_BORAD

  • AMIN_BOARD_INDEX — varchar2(30) — Primary key — NOT NULL
  • AMIN_TITLE — varchar2(30) — NOT NULL
  • AMIN_INFO — varchar2(3000) — NOT NULL
  • AMIN_IMG — varchar2(30) — NOT NULL
  • AMIN_PRICE — varchar2(30) — NOT NULL
  • AMIN_OPT — varchar2(20) — NOT NULL
  • AMIN_OPT2 — varchar2(20) — NOT NULL
  • AMIN_OPT3 — varchar2(20) — NOT NULL
  • AMIN_OPT4 — varchar2(20) — NOT NULL
  • AMIN_TIM — varchar2(1) — NOT NULL
  • AMIN_SOME_IMG — varchar2(30) — NOT NULL

TB_AMIN_UR

  • USER_BOARD_INDEX — VARCHAR2(12) — Foreign key → TB_USER_BOARD.USER_BOARD_INDEX — NOT NULL
  • AMIN_TIM — VARCHAR2(1) — NOT NULL
  • AMIN_USER_CONTENTS — VARCHAR2(3000)
  • AMIN_DATE — DATE — NOT NULL

TB_BASKET

  • BASKET_INDEX — VARCHAR2(30) — Primary key — NOT NULL
  • BASKET_TITLE — VARCHAR2(30) — NOT NULL
  • BASKET_PRICE — NUMBER — NOT NULL
  • BASKET_OPT — VARCHAR2(20) — NOT NULL
  • BASKET_OPT2 — VARCHAR2(20) — NOT NULL
  • BASKET_OPT3 — VARCHAR2(20) — NOT NULL
  • BASKET_OPT4 — VARCHAR2(20) — NOT NULL
  • AMIN_BOARD_INDEX (AMIN_BOARD_INDEX2) — varchar2(30) — Foreign key → TB_AMIN_BORAD.AMIN_BOARD_INDEX — NOT NULL

TB_MEMBER

  • USER_NUM — VARCHAR2(12) — Primary key — NOT NULL
  • USER_ID — varchar2(20) — NOT NULL
  • USER_PW — varchar2(20) — NOT NULL
  • USER_NAME — varchar2(30) — NOT NULL
  • USER_PHONE — varchar2(13) — NOT NULL
  • USER_EMAIL — varchar2(40) — NOT NULL
  • USER_ZIPCODE — varchar2(7) — NOT NULL
  • USER_ADDRESS1 — varchar2(200) — NOT NULL
  • USER_ADDRESS2 — varchar2(200) — NOT NULL
  • AMIN_TIM — varchar2(1) — NOT NULL

TB_NOTICE_BORAD

  • AMIN_NOTICE_INDEX — VARCHAR2(30) — Primary key — NOT NULL
  • AMIN_NOTICE_TITLE — VARCHAR2(30) — NOT NULL
  • AMIN_NOTICE_CONTENTS — VARCHAR2(3000)
  • AMIN_NOTICE_IMG — VARCHAR2(30) — NOT NULL
  • AMIN_NOTICE_TIM — VARCHAR2(1) — NOT NULL

TB_USER_BOARD

  • USER_BOARD_INDEX — VARCHAR2(12) — Primary key — NOT NULL
  • USER_TITLE — VARCHAR2(30) — NOT NULL
  • USER_CONTENTS — VARCHAR2(3000) — NOT NULL
  • USER_ID — VARCHAR2(20) — NOT NULL
  • USET_DATA — DATE — NOT NULL
  • USER_IMG — VARCHAR2(36) — NOT NULL
  • AMIN_BOARD_INDEX — varchar2(30) — Foreign key → TB_AMIN_BORAD.AMIN_BOARD_INDEX — NOT NULL
  • USER_NUM — VARCHAR2(12) — Foreign key → TB_MEMBER.USER_NUM — NOT NULL
  • PAY_USER_ORDERNUM — VARCHAR2(30) — Foreign key → TB_USER_PAY.PAY_USER_ORDERNUM — NOT NULL

TB_USER_PAY

  • PAY_USER_ORDERNUM — VARCHAR2(30) — Primary key — NOT NULL
  • PAY_USER_NAME — varchar2(30) — NOT NULL
  • PAY_USER_PHONE — varchar2(13) — NOT NULL
  • PAY_USER_ZIPCODE — varchar2(7) — NOT NULL
  • PAY_USER_ADDRESS1 — varchar2(40) — NOT NULL
  • PAY_USER_ADDRESS2 — varchar2(200) — NOT NULL
  • PAY_AMIN_TITLE — VARCHAR2(30) — NOT NULL
  • PAY_AMIN_PRICE — number — NOT NULL
  • PAY_AMIN_OPT — varchar2(20) — NOT NULL
  • PAY_AMIN_OPT2 — varchar2(20) — NOT NULL
  • PAY_AMIN_OPT3 — varchar2(20) — NOT NULL
  • PAY_AMIN_OPT4 — varchar2(20) — NOT NULL
  • PAY_INFO — VARCHAR2(30)
  • PAY_TRANS — VARCHAR2(6)
  • AMIN_BOARD_INDEX — varchar2(30) — Foreign key → TB_AMIN_BORAD.AMIN_BOARD_INDEX — NOT NULL