패스터

테이블 (8)

ADMIN

  • ADMIN_IDX — int
  • ADMIN_NAME — varchar(64) — NOT NULL
  • ADMIN_NICKNAME — varchar(64) — NOT NULL
  • ADMIN_POSITION — varchar(32) — NOT NULL
  • ADMIN_EMAIL — varchar(64) — NOT NULL
  • ADMIN_PASSWORD — varchar(256) — NOT NULL
  • ADMIN_CREATED_AT — datetime — NOT NULL
  • ADMIN_RULE — varchar(64) — NOT NULL

PRODUCT 수정 (CopyOfPRODUCT)

  • PRODUCT_IDX — int
  • SHOP_IDX — int — NOT NULL
  • PRODUCT_NAME — varchar(45) — NOT NULL
  • PRODUCT_IMG — varchar(400) — NOT NULL
  • PRODUCT_PRICE — varchar(45) — NOT NULL
  • PRODUCT_LEAST_ORDER_NUM — varchar(45) — NOT NULL
  • UPLOAD_DATE — datetime — NOT NULL
  • PRODUCT_EXP — tinyint — NOT NULL
  • PRODUCT_COUNTRY — int — NOT NULL
  • PRODUCT_COUNTRY_NAME — varchar(45) — NOT NULL
  • PRODUCT_COMPOSITION — varchar(45) — NOT NULL
  • PRODUCT_EXPLANATION — varchar(400) — NOT NULL
  • PRODUCT_STATE — tinyint — NOT NULL

PRODUCT 원래 (PRODUCT)

  • PRODUCT_IDX — int
  • SHOP_IDX — int — NOT NULL
  • PRODUCT_NAME — varchar(45) — NOT NULL
  • PRODUCT_IMG — varchar(400) — NOT NULL
  • PRODUCT_PRICE — varchar(45) — NOT NULL
  • PRODUCT_LEAST_ORDER_NUM — varchar(45) — NOT NULL
  • UPLOAD_DATE — datetime — NOT NULL
  • PRODUCT_EXP — tinyint — NOT NULL
  • PRODUCT_COUNTRY — int — NOT NULL
  • PRODUCT_COUNTRY_NAME — varchar(45) — NOT NULL
  • PRODUCT_COMPOSITION — varchar(45) — NOT NULL
  • PRODUCT_EXPLANATION — varchar(400) — NOT NULL
  • IS_UPDATED — tinyint — NOT NULL

PRODUCT_LOG

  • PRODUCT_LOG_IDX — int
  • TOTAL_CNT — int — NOT NULL
  • ACTIVE_CNT — int — NOT NULL
  • CREATED_AT — datetime

SHOP 수정 (CopyOfSHOP)

  • SHOP_IDX — int — 기본 키 — NOT NULL
  • SHOP_NAME — varchar(45) — NOT NULL
  • SHOP_EMAIL — varchar(200) — NOT NULL
  • SHOP_PW — varchar(200) — NOT NULL
  • SALT — varchar(400) — NOT NULL
  • SHOP_ADDRESS — varchar(400)
  • SHOP_TEL — varchar(45) — NOT NULL
  • REFRESH_TOKEN — varchar(200) — NOT NULL
  • SHOP_STATE — tinyint — NOT NULL
  • SHOP_LOCATION (층 / 호수) — varchar(32) — NOT NULL
  • SHOP_OPERATOR (담당자 이름) — varchar(32) — NOT NULL
  • BANK (은행명) — varchar(128) — NOT NULL
  • ACCOUNT_NUMBER (계좌번호) — varchar(256) — NOT NULL
  • ACCOUNT_HOLDER (예금주) — varchat(256) — NOT NULL
  • RECOMMENDER (추천인) — varchat(256)
  • STORE_IDX (상가 외래키) — int — 외래 키 → STORE.STORE_IDX — NOT NULL

SHOP_LOG

  • SHOP_LOG_IDX — int
  • TOTAL_CNT — int — NOT NULL
  • ACTIVE_CNT — int
  • CREATED_AT — datetime — NOT NULL

SHOP원본 (SHOP)

  • SHOP_IDX — int — 기본 키 — NOT NULL
  • SHOP_NAME — varchar(45) — NOT NULL
  • SHOP_ID — varchar(45) — NOT NULL
  • SHOP_PW — varchar(200) — NOT NULL
  • SALT — varchar(400) — NOT NULL
  • SHOP_ADDRESS — varchar(400) — NOT NULL
  • SHOP_TEL — varchar(45) — NOT NULL
  • REFRESH_TOKEN — varchar(200) — NOT NULL

STORE (상가)

  • STORE_IDX (상가 인덱스) — int — 기본 키 — NOT NULL
  • STORE_NAME (상가명) — varchar(128) — NOT NULL
  • STORE_ADDRESS (상가주소) — varchar(512) — NOT NULL