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