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