소상공인노쇼방지플랫폼ERD

테이블 (7)

BUSINESS

  • BIZ_ID — INT
  • MEMBER_ID — VARCHAR(20) — NOT NULL
  • BIZ_NAME — VARCHAR(50) — NOT NULL
  • ADDRESS — VARCHAR(100)
  • PHONE — VARCHAR(13)
  • CATEGORY — VARCHAR(30)
  • OPEN_TIME — TIME
  • CLOSE_TIME — TIME
  • REGISTERED_AT — DATETIME

MEMBER

  • MEMBER_ID — VARCHAR(20)
  • PASSWORD — VARCHAR(100) — NOT NULL
  • NAME — VARCHAR(30) — NOT NULL
  • PHONE — VARCHAR(13) — NOT NULL
  • EMAIL — VARCHAR(50) — NOT NULL
  • TYPE — VARCHAR(10) — NOT NULL
  • JOINED_AT — DATETIME

NOSHOW

  • NS_ID — INT
  • RSV_ID — INT — NOT NULL
  • REASON — VARCHAR(100)
  • OCCUR_DATE — DATE
  • ACCUM_COUNT — INT

PAYMENT

  • PAY_ID — INT
  • RSV_ID — INT — NOT NULL
  • AMOUNT — DECIMAL(10,2) — NOT NULL
  • METHOD — VARCHAR(20) — NOT NULL
  • PAY_DATE — DATETIME
  • REFUND_FLAG — BOOLEAN

RESERVATION

  • RSV_ID — INT
  • MEMBER_ID — VARCHAR(20) — NOT NULL
  • BIZ_ID — INT — NOT NULL
  • RSV_DATE — DATE — NOT NULL
  • RSV_TIME — TIME — NOT NULL
  • PEOPLE_COUNT — INT — NOT NULL
  • STATUS — VARCHAR(20)
  • CREATED_AT — DATETIME

REVIEW

  • REV_ID — INT
  • MEMBER_ID — VARCHAR(20) — NOT NULL
  • BIZ_ID — INT — NOT NULL
  • SCORE — INT
  • CONTENT — VARCHAR(255)
  • REV_DATE — DATETIME

REWARD

  • RW_ID — INT
  • MEMBER_ID — VARCHAR(20) — NOT NULL
  • POINT — INT
  • TYPE — VARCHAR(10)
  • EVENT_DATE — DATETIME
  • REASON — VARCHAR(100)