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