asdf
Tables (43)
ADMIN
- SEQ — int
- USERNAME — varchar(40)
- PASSWORD — varchar(40)
- NAME — varchar(40)
- PHONE — int
- LAST_LOG — timestamp
- IS_SUPER — int
- IS_DELETE — int
ALARM
- USER_SEQ — int — NOT NULL
- STORE_SEQ — int
- TYPE — int
- IS_CHECK — tinyint(1)
- FOREIGN_KEY — int
- REG_DATE — timestamp
APP_TERMS
- USER_SEQ — int
- SERVICE — tinyint(1)
- PRIVACY — tinyint(1)
- LOCATION — tinyint(1)
APP_TERMS_CONTENT
- TYPE — int
- CONTENT — text
APP_VERSION
- TYPE — int
- VERSION — varchar(30)
AUTH
- SEQ — int
- ADMIN_SEQ — int
- AUTH_CODE — varchar(24)
- AUTH_NAME — varchar(40)
BLOCK
- SEQ — int
- USER_SEQ — int
- BLOCK_USER_SEQ — int
BOARD
- SEQ — int
- USER_SEQ — int — NOT NULL
- CATEGORY_SEQ — int
- TITLE — varchar(100) — NOT NULL
- CONTENT — text — NOT NULL
- IS_DELETE — tinyint(1) — NOT NULL
- REG_DATE — timestamp — NOT NULL
- UPDATE_DATE — timestamp
- DELETE_DATE — timestamp
- IS_STORE_CHECK — tinyint(1)
- VIEW_COUNT — int
BOARD_FILE_LOG
- SEQ — int
- BOARD_SEQ — int — NOT NULL
- IMG_PATH — text
- IMG_NAME — text
- IMG_URL — text
BOARD_TAG
- SEQ — int
- BOARD_SEQ — int
- CONTENT — varchar(80)
CATEGORY_CONTENT
- SEQ — int
- MAIN_SEQ — int
- MAIN_CATE — int — NOT NULL
- SUB_CATE — int — NOT NULL
- NAME — varchar(80) — NOT NULL
- IMG_NAME — text
- IMG_PATH — text
- IMG_URL — text
- HOME_IMG_NAME — text
- HOME_IMG_PATH — text
- HOME_IMG_URL — text
- REG_DATE — timestamp — NOT NULL
CATEGORY_GROUP
- MAIN_CATE — int
- SUB_CATE — int
COMMENT
- BOARD_SEQ); — ( SEQ int auto_increment primary key USER_SEQ int not null — NOT NULL
- BOARD_SEQ — int — NOT NULL
- COMMENT — (USER_SEQ);_SEQ — NOT NULL — USER_SEQ);_SEQ int null CONTENT text not nul
- REG_DATE — timestamp — NOT NULL
- IS_DELETE — tinyint(1) — NOT NULL
- DELETE_DATE — timestamp
- IS_STORE_CHECK — tinyint(1)
- UPDATE_DATE — timestamp
- _ibfk_1 — foreign — ext nul
- _ibfk_2 — foreign
FAQ
- SEQ — int
- ADMIN_SEQ — int
- TITLE — varchar(100) — NOT NULL
- CONTENT — text — NOT NULL
- REG_DATE — timestamp — NOT NULL
- IS_MASTER — tinyint(1) — NOT NULL
- IS_DELETE — tinyint(1) — NOT NULL
FAVORITE
- SEQ — int
- USER_SEQ — int
- STORE_SEQ — int
- BOARD_SEQ — int
HISTORY
- SEQ — int
- USER_SEQ — int
- STORE_SEQ — int
- RESERV_SEQ — int
- TYPE — tinyint(1)
- IS_STATE — int
- APPLY_DATE — timestamp
INQUIRY
- SEQ — int
- USER_SEQ — int — NOT NULL
- STORE_SEQ — int
- TITLE — varchar(100) — NOT NULL
- CONTENT — text — NOT NULL
- REG_DATE — timestamp — NOT NULL
- COMMENT — tinyint(1) — inyint(1) default 1 nul
- undefined_REG_DATE — timestamp — NOT NULL
- IS_ACCEPT — tinyint(1) — NOT NULL
MAIN_CATEGORY
- SEQ — int
- STORE_SEQ — int — NOT NULL
- MAIN_CATEGORY_SEQ — int — NOT NULL
- CATEGORY_NAME — varchar(80) — NOT NULL
MASTER
- USER_SEQ — int — Primary key — NOT NULL
- STORE_SEQ — int — Primary key — NOT NULL
NOTICE
- SEQ — int
- ADMIN_SEQ — int — NOT NULL
- TITLE — varchar(100) — NOT NULL
- CONTENT — text — NOT NULL
- REG_DATE — timestamp — NOT NULL
- IS_MASTER — tinyint(1) — NOT NULL
- IS_DELETE — tinyint(1) — NOT NULL
NOTICE_ALARM
- NOTICE_SEQ — int
- IS_CHECK — tinyint(1)
- IS_MASTER — tinyint(1)
- REG_DATE — timestamp
NOTICE_FILE_LOG
- SEQ — int
- NOTICE_SEQ — int — NOT NULL
- IMG_PATH — text
- IMG_NAME — text
- IMG_URL — text
PV
- DATE — date — Primary key — NOT NULL
- TYPE — int — Primary key — NOT NULL
- COUNT — int
PV_TYPE
- SEQ — int
- TYPE — varchar(100)
- NAME — varchar(100)
REPORT
- SEQ — int
- USER_SEQ — int — NOT NULL
- BOARD_SEQ — int
- REPORTED_BOARD_SEQ — int
- REPORTED_undefined_SEQ — int
- REPORTED_REVIEW_SEQ — int
- IS_REPORT — int — NOT NULL
- REPORT_REASON_TYPE — int — NOT NULL
- REPORT_REASON — text — NOT NULL
- IS_STATE — int — NOT NULL
RESERV
- SEQ — int
- USER_SEQ — int — NOT NULL
- STORE_SEQ — int — NOT NULL
- REG_DATE — timestamp — NOT NULL
- RESERV_TYPE — int — NOT NULL
- USER_NAME — varchar(100) — NOT NULL
- USER_PHONE — varchar(40) — NOT NULL
- STORE_NAME — varchar(100) — NOT NULL
- RESERV_DATE — timestamp — NOT NULL
- IS_PROVIDE_PHONE — tinyint(1) — NOT NULL
- IS_RESPONSE — int
- REJECT_REASON_TYPE — int
- REJECT_REASON — text
- CANCEL_REASON_TYPE — int
- CANCEL_REASON — text
REVIEW
- SEQ — int
- USER_SEQ — int — NOT NULL
- STORE_SEQ — int — NOT NULL
- CONTENT — text — NOT NULL
- STARPOINT — mediumtext — NOT NULL
- REG_DATE — timestamp
- IS_DELETE — tinyint(1) — NOT NULL
- DELETE_DATE — timestamp
- undefined — undefined_REG_DATE — NOT NULL
- REFUSE_TYPE — int
- REFUSE_REASON — text
- TITLE — varchar(100)
REVIEW_FILE_LOG
- SEQ — int
- REVIEW_SEQ — int — NOT NULL
- IMG_PATH — text
- IMG_NAME — text
- IMG_URL — text
SEARCH_KEYWORD
- KEYWORD — varchar(100) — Primary key — NOT NULL
- REG_DATE — date — Primary key — NOT NULL
- COUNT — int — NOT NULL
STATISTICS
- STORE_SEQ — int — Primary key — NOT NULL
- TYPE — int — Primary key — NOT NULL
- DATE — date — Primary key — NOT NULL
- COUNT — int
STATISTICS_TYPE
- TYPE — int
- NAME — varchar(40)
STORE
- SEQ — int
- USER_SEQ — int
- BUSINESS_NUM — varchar(10)
- BUSINESS_REG_FILE_NAME — text
- BUSINESS_REG_FILE_PATH — text
- BUSINESS_REG_FILE_URL — text
- NAME — varchar(100) — NOT NULL
- PHONE — varchar(40) — NOT NULL
- ADDRESS — varchar(200)
- LATITUDE — decimal(18, 10)
- LONGITUDE — decimal(18, 10)
- IMG_NAME — text
- IMG_PATH — text
- IMG_URL — text
- CALL_COUNT — int
- SATISFACTION — int
- REPAIR_PROGRESS — int
- IS_ACCEPT — int — NOT NULL
- ACCEPT_DATE — timestamp
- REFUSE — text
- IS_ACTIVE — tinyint(1)
- IS_BAN — tinyint(1)
- WITHDRAWAL_TYPE — int
- WITHDRAWAL_REASON — text
- BAN_REASON_TYPE — int
- BAN_REASON — text
- DELETE_DATE — timestamp
- IS_RESERV — tinyint(1) — NOT NULL
- INTRO — text
- RESERV_TYPE — int
- ALARM_REVIEW — tinyint(1)
- ALARM_NOTICE — tinyint(1)
- ALARM_INQUIRY — tinyint(1)
- ALARM_RESERV — tinyint(1)
STORE_ALARM_MANAGE
- STORE_SEQ — int
- USER_SEQ — int
- DEVICE_UUID — varchar(80) — NOT NULL
- DEVICE_TOKEN — text
- ALARM_REVIEW — tinyint(1)
- ALARM_NOTICE — tinyint(1)
- ALARM_INQUIRY — tinyint(1)
- ALARM_RESERV — tinyint(1)
STORE_APPLY_FILE_LOG
- SEQ — int
- STORE_SEQ — int
- IMG_PATH — text
- IMG_NAME — text
- IMG_URL — text
STORE_FILE_LOG
- SEQ — int
- STORE_SEQ — int — NOT NULL
- IMG_PATH — text
- IMG_NAME — text
- IMG_URL — text
STORE_OPERATING_HOUR
- WEEK — int — Primary key — NOT NULL
- STORE_SEQ — int — Primary key — NOT NULL
- START_OPERATING_TIME — time
- END_OPERATING_TIME — time
- START_BREAK_TIME — time
- END_BREAK_TIME — time
STORY
- SEQ — int
- STORE_SEQ — int
- TITLE — varchar(100) — NOT NULL
- CONTENT — text — NOT NULL
- STORE_NAME — varchar(100) — NOT NULL
- CATEGORY1 — varchar(80)
- CATEGORY2 — varchar(80)
- CATEGORY3 — varchar(80)
- IMG_NAME — text
- IMG_PATH — text
- IMG_URL — text
- PHONE — varchar(40)
- ADDRESS — varchar(200)
- LOCATION — varchar(200) — NOT NULL
- REG_DATE — timestamp — NOT NULL
- IS_DELETE — tinyint(1) — NOT NULL
- DELETE_DATE — timestamp
STORY_FILE_LOG
- SEQ — int
- STORY_SEQ — int
- IMG_PATH — text
- IMG_NAME — text
- IMG_URL — text
SUB_CATEGORY
- SEQ — int
- STORE_SEQ — int — NOT NULL
- STORE_MAIN_CATEGORY — int — NOT NULL
- SUB_CATEGORY_SEQ — int — NOT NULL
- CATEGORY_NAME — varchar(80) — NOT NULL
TAG
- SEQ — int
- STORE_SEQ — int — NOT NULL
- TAG_SEQ — int — NOT NULL
- TAG_NAME — varchar(80) — NOT NULL
TAG_CONTENT
- SEQ — int
- NAME — varchar(80) — NOT NULL
- IMG_PATH — text
- IMG_NAME — text
- IMG_URL — text
- REG_DATE — timestamp — NOT NULL
USER
- SEQ — int
- EMAIL — varchar(40)
- NAME — varchar(100) — NOT NULL
- PHONE — varchar(40) — NOT NULL
- ESG — int
- IMG_PATH — text
- IMG_NAME — text
- IMG_URL — text
- REG_DATE — date — NOT NULL
- LAST_LOG — timestamp
- IS_ACTIVE — tinyint(1)
- IS_BAN — tinyint(1)
- BAN_REASON_TYPE — int
- BAN_REASON — text
- WITHDRAWAL_TYPE — int
- WITHDRAWAL_REASON — text
- DELETE_DATE — timestamp
- SOCIAL_TYPE — int — NOT NULL
- ROLE — int — NOT NULL
USER_ALARM_MANAGE
- USER_SEQ — int
- DEVICE_UUID — varchar(80)
- DEVICE_TOKEN — text
- ALARM_undefined — ALARM_NESTED_undefined
- ALARM_NOTICE — tinyint(1)
- ALARM_INQUIRY — tinyint(1)