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