Cosmetic-Kingdom
Tables (7)
ANNOUNCEMENTS (announcement)
- 공지ID (ANNOUNCEMENT_ID) — BIGINT — Primary key
- 제목 (TITLE) — VARCHAR(200) — NOT NULL
- 내용 (CONTENT) — TEXT — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME — NOT NULL
REVIEWS (review)
- 리뷰ID (REVIEW_ID) — BIGINT — Primary key — NOT NULL
- 유저ID (USER_ID) — BIGINT — Foreign key → users.유저ID — NOT NULL
- 마사지ID (MASSAGE_ID) — BIGINT — Foreign key → massages.마사지ID — NOT NULL
- 댓글 (COMMENT) — VARCHAR(1000)
- 평점 (RATING) — INT — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME — NOT NULL
USER_NOTIFICATION_SETTINGS (user_notification_setting)
- 셋팅ID (SETTING_ID) — BIGINT — Primary key — NOT NULL
- 유저ID (USER_ID) — BIGINT — Foreign key → users.유저ID — NOT NULL
- PUSH_ENABLED — BOOLEAN — NOT NULL
- EMAIL_ENABLED — BOOLEAN — NOT NULL
- SMS_ENABLED — BOOLEAN — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME — NOT NULL
WAITLISTS (waitlist)
- 대기자ID (WAITLIST_ID) — BIGINT — Primary key — NOT NULL
- 마사지ID (MASSAGES_ID) — BIGINT — Foreign key → massages.마사지ID — NOT NULL
- 유저ID (USER_ID) — BIGINT — Foreign key → users.유저ID — NOT NULL
- 상태 (STATUS) — VARCHAR(20) — NOT NULL
- CREATED_AT — DATETIME — NOT NULL
- UPDATED_AT — DATETIME — NOT NULL
massages (massage)
- 마사지ID (MASSAGE_ID) — BIGINT — Primary key — NOT NULL
- 마사지이름 (NAME) — VARCHAR(100) — NOT NULL
- 설명 (DESCRIPTION) — VARCHAR(500)
- 가격 (PRICE) — DOUBLE — NOT NULL
- 소요시간 (DURATION_MINUTES) — INT — NOT NULL
- created_at (CREATED_AT) — DATETIME — NOT NULL
- updated_at (UPDATED_AT) — DATETIME — NOT NULL
reservations (reservation)
- 예약ID (RESERVATION_ID) — BIGINT — Primary key — NOT NULL
- 유저ID (USER_ID) — BIGINT — Foreign key → users.유저ID — NOT NULL
- 마사지ID (MASSAGES_ID) — BIGINT — Foreign key → massages.마사지ID — NOT NULL
- 예약시간 (RESERVATION_TIME) — DATETIME — NOT NULL
- 상태 (STATUS) — VARCHAR(20) — NOT NULL
- created_at (CREATED_AT) — DATETIME — NOT NULL
- updated_at (UPDATED_AT) — DATETIME — NOT NULL
users (user)
- 유저ID (USER_ID) — BIGINT — Primary key — NOT NULL
- 유저이름 (LOGIN_ID) — VARCHAR(50) — NOT NULL
- 이메일 (EMAIL) — VARCHAR(100) — NOT NULL
- 패스워드 (PASSWORD) — VARCHAR(255) — NOT NULL
- 성함 (NAME) — VARCHAR(100)
- 역햘 (ROLE) — VARCHAR(20) — NOT NULL
- created_at (CREATED_AT) — DATETIME — NOT NULL
- updated_at (UPDATED_AT) — DATETIME — NOT NULL