test
Tables (16)
BB_ORDER
- ORDER_NUM — INT
- MEMBER_NUM — INT — NOT NULL
- ADMIN_CHECKED — CHAR(1)
- ORDER_DATE — DATETIME
- ORDER_ADDRESS — VARCHAR(100)
- CHECK — (ADMIN_CHECKED IN ('Y', 'N', 'C'))
BB_ORDER_DETAIL
- ORDER_DETAIL_NUM — INT
- PRODUCT_NUM — INT
- ORDER_QUANTITY — INT
- ORDER_NUM — INT
BB_PAYMENT
- PAYMENT_NUM — INT
- MEMBER_NUM — INT — NOT NULL
- PAYMENT_AMOUNT — INT — NOT NULL
- PAYMENT_AT — DATETIME
- PAYMENT_NAME — VARCHAR(100) — NOT NULL
- IMP_UUID — VARCHAR(100)
- ADMIN_CHECKED — CHAR(1)
bb_board
- BOARD_NUM — int — Primary key — NOT NULL
- BOARD_TITLE — varchar(500) — NOT NULL
- BOARD_CONTENT — varchar(1000)
- BOARD_FOLDER — varchar(1000)
- MEMBER_NUM — int — Foreign key → bb_member.MEMBER_NUM
- BOARD_WRITE_DAY — datetime
- BOARD_OPEN — char(1)
- BOARD_CATEGORY_NUM — int — Foreign key → bb_board_category.BOARD_CATEGORY_NUM
- STORE_NUM — int — Foreign key → bb_store.STORE_NUM
- PRODUCT_NUM — int — Foreign key → bb_product.PRODUCT_NUM
- BOARD_DELETE — char(1)
bb_board_category
- BOARD_CATEGORY_NUM — int — Primary key — NOT NULL
- BOARD_CATEGORY_NAME — varchar(30) — NOT NULL
bb_declare
- DECLARE_NUM — int — Primary key — NOT NULL
- STORE_NUM — int — Foreign key → bb_store.STORE_NUM
- DECLARE_CONTENT — varchar(1000)
bb_like
- LIKE_NUM — int — Primary key — NOT NULL
- BOARD_NUM — int — Foreign key → bb_board.BOARD_NUM — NOT NULL
- MEMBER_NUM — int — Foreign key → bb_member.MEMBER_NUM
bb_member
- MEMBER_NUM — int — Primary key — NOT NULL
- MEMBER_EMAIL — varchar(200) — NOT NULL
- MEMBER_PASSWORD — varchar(100) — NOT NULL
- MEMBER_NAME — varchar(30) — NOT NULL
- MEMBER_NICKNAME — varchar(50) — NOT NULL
- MEMBER_PHONE — varchar(20)
- MEMBER_PROFILE_WAY — varchar(500)
- MEMBER_ROLE — varchar(30)
- MEMBER_HIREDAY — datetime
- # — UNIQUE
- # — UNIQUE
bb_point
- POINT_NUM — int — Primary key — NOT NULL
- MEMBER_NUM — int — Foreign key → bb_member.MEMBER_NUM
- POINT_PLUS — int
- POINT_MINUS — int
- POINT_CONTENT — varchar(100)
bb_product
- PRODUCT_NUM — int — Primary key — NOT NULL
- PRODUCT_NAME — varchar(100) — NOT NULL
- PRODUCT_PRICE — int — NOT NULL
- PRODUCT_PROFILE_WAY — varchar(500) — NOT NULL
- PRODUCT_CATEGORY_NUM — int — Foreign key → bb_product_category.PRODUCT_CATEGORY_NUM
bb_product_category
- PRODUCT_CATEGORY_NUM — int — Primary key — NOT NULL
- PRODUCT_CATEGORY_NAME — varchar(30) — NOT NULL
bb_reply
- REPLY_NUM — int — Primary key — NOT NULL
- REPLY_CONTENT — varchar(500) — NOT NULL
- MEMBER_NUM — int — Foreign key → bb_member.MEMBER_NUM
- REPLY_WRITE_DAY — datetime
- BOARD_NUM — int — Foreign key → bb_board.BOARD_NUM
bb_store
- STORE_NUM — int — Primary key — NOT NULL
- STORE_NAME — varchar(100) — NOT NULL
- STORE_ADDRESS — varchar(500) — NOT NULL
- STORE_ADDRESS_DETAIL — varchar(100) — NOT NULL
- STORE_CONTACT — varchar(20)
- STORE_CLOSED — char(1)
- STORE_SECRET — char(1)
bb_store_menu
- STORE_MENU_NUM — int — Primary key — NOT NULL
- STORE_NUM — int — Foreign key → bb_store.STORE_NUM — NOT NULL
- STORE_MENU_NORMAL — varchar(1)
- STORE_MENU_VEG — char(1)
- STORE_MENU_MINI — char(1)
- STORE_MENU_POTATO — char(1)
- STORE_MENU_ICE — char(1)
- STORE_MENU_CHEESE — char(1)
- STORE_MENU_PASTRY — char(1)
- STORE_MENU_OTHER — char(1)
bb_store_payment
- STORE_PAYMENT_NUM — int — Primary key — NOT NULL
- STORE_NUM — int — Foreign key → bb_store.STORE_NUM — NOT NULL
- STORE_PAYMENT_CASHMONEY — char(1)
- STORE_PAYMENT_CARD — char(1)
- STORE_PAYMENT_ACCOUNT — char(1)
bb_store_work
- WORK_NUM — int — Primary key — NOT NULL
- STORE_NUM — int — Foreign key → bb_store.STORE_NUM — NOT NULL
- STORE_WORK_WEEK — char(3) — NOT NULL
- STORE_WORK_OPEN — datetime — NOT NULL
- STORE_WORK_CLOSE — datetime — NOT NULL