소상공인노쇼방지플랫폼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)