패스터
테이블 (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