lifehouse

Tables (6)

admin

  • 아이디 (id) — bigserial — Primary key — NOT NULL
  • keycloak 아이디 (keycloak_id) — varchar(100)
  • 이름 (firstname) — varchar(15)
  • 성 (lastname) — varchar(15)
  • 계정 (username) — varchar(20)
  • 비밀번호 (password) — varchar(100)
  • 모바일번호 (mobile_number) — varchar(13)
  • 요청일자 (requested_at) — timestamp
  • 승인자 (approved_by) — bigserial
  • 승인일자 (approved_at) — timestamp
  • 역할 (role) — varchar(10)
  • 승인여부 (is_approved) — boolean
  • 생성일자 (created_at) — timestamp
  • 생성자 (created_by) — bigserial
  • 수정일자 (modified_at) — timestamp
  • 수정자 (modified_by) — bigserial

booking (예약)

  • ID (id) — bigserial — Primary key — NOT NULL
  • 게스트ID (guest_id) — bigserial — Foreign key → guest.ID — NOT NULL
  • 방ID (room_id) — bigserial — Foreign key → room.ID — NOT NULL
  • 관리자ID (admin_id) — bigserial — Foreign key → admin.아이디 — NOT NULL
  • 목적 (purpose) — varchar(20)
  • 인원 (head_count) — integer
  • 입실일자 (checkin_at) — date
  • 퇴실일자 (checkout_at) — date
  • 상태 (status)
  • 생성일자 (created_at) — timestamp
  • 생성자 (created_by) — bigserial
  • Field

booking_payment (예약금 관리)

  • ID (id) — bigserial — Primary key — NOT NULL
  • 예약금 (deposit) — numeric
  • 잔금 (balance) — numeric
  • 생성일자 (created_date) — timestamp
  • Field

booking_sms (Untitled)

  • ID (id) — bigserial — Primary key — NOT NULL
  • 예약ID (booking_id) — bigserial — Foreign key → booking.ID — NOT NULL
  • 게스트ID (guest_id) — bigserial — Foreign key → booking.게스트ID — NOT NULL
  • 아이디 (id2) — bigserial — Foreign key → booking.관리자ID — NOT NULL
  • 제목 (title) — varchar(50)
  • 내용 (msg) — varchar(2000)
  • 예약발송여부 (is_reserved) — boolean
  • 발송일자 (sent_at) — timestamp
  • 발송자 (sent_by) — bigserial
  • 생성일자 (created_at) — timestamp
  • 생성자 (created_by) — bigserial
  • 수정일자 (modified_at) — timestamp
  • 수정자 (modified_by) — bigserial

guest (게스트)

  • ID (id) — bigserial — Primary key — NOT NULL
  • 이름 (firstname) — varchar(15)
  • 성 (lastname) — varchar(15)
  • 성별 (gender) — char(1)
  • 모바일번호 (mobile_number) — varchar(13)
  • 생성일자 (created_at) — timestamp
  • 생성자 (created_by) — bigserial
  • 수정일자 (modified_at) — timestamp
  • 수정자 (modified_by) — bigserial

room (룸)

  • ID (id) — bigserial — Primary key — NOT NULL
  • 이름 (name) — varchar(15)
  • Field