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)