wedding-registry
Tables (8)
account_transfer (AccountTransfer)
- id (account_transfer_id) — Integer — Primary key — NOT NULL
- id (boards_id) — Boards — Foreign key → boards.id — NOT NULL
- 계좌 이체 메모 내용 (transfer_memo) — Text
- 생성일 (created_at) — Datetime
- 수정일 (updated_at) — Datetime
- 삭제일 (deleted_at) — Boolean(false)
boards (Boards)
- id (boards_id) — Integer — Primary key — NOT NULL
- 공유페이지 소유자 (users_id) — Users — Foreign key → users.id — NOT NULL
- uuid1 (uuid_first) — varchar
- uuid2 (uuid_second) — varchar
- 신랑이름 (husband_name) — varchar
- 신랑 은행 (husband_bank) — varchar
- 신랑 계좌 (husband_account) — varchar
- 신부이름 (wife_name) — varchar
- 신부은행 (wife_bank) — varchar
- 신부계좌 (wife_account) — varchar
- 결혼식 장소 (address) — varchar
- 결혼식 날짜 (wedding_date) — date
- 결혼식 시간 (wedding_time) — time
- 보드 메모 내용 (boards_memo) — Text
- 생성일 (created_at) — Datetime
- 수정일 (updated_at) — Datetime
- 삭제일 (deleted_at) — Boolean(false)
gallery_img (GalleryImg)
- id (gallery_img_id) — Integer — Primary key — NOT NULL
- id (boards_id) — Integer — Foreign key → boards.id — NOT NULL
- 이미지 url (gallery_img_url) — varchar
goods (Goods)
- id (goods_id) — Integer — Primary key — NOT NULL
- 이미지 url (goods_img_url) — varchar
- 상품 url (goods_url) — varchar
- 상품명 (goods_name) — varchar
- 상품가격 (goods_price) — Integer
- 커머스 (commerce) — varchar
- 생성일 (created_at) — Datetime
- 수정일 (updated_at) — Datetime
- 삭제일 (deleted_at) — Boolean(false)
goods_donation (GoodsDonation)
- id (goods_donation_id) — Integer — Primary key — NOT NULL
- id (guests_id) — Guests — Foreign key → guests.id — NOT NULL
- id (users_goods_id) — UsersGoods — Foreign key → users_goods.id — NOT NULL
- 상품 후원 금액 (goods_donation_amount) — Integer
- 생성일 (created_at) — Datetime
- 수정일 (updated_at) — Datetime
- 삭제일 (deleted_at) — Boolean(false)
guests (Guests)
- id — Integer — Primary key — NOT NULL
- id (users_id) — Users -> guest를 의미 — Foreign key → users.id — NOT NULL
- id (boards_id) — Boards — Foreign key → boards.id — NOT NULL
- 참석 불참석 (attendance) — varchar(no, yes, unknown)
- 생성일 (created_at) — Datetime
- 수정일 (updated_at) — Datetime
- 삭제일 (deleted_at) — Boolean(false)
users (Users)
- id (users_id) — Integer — Primary key — NOT NULL
- 초대자 아이디 (parent_id) — Users — Foreign key → users.id — NOT NULL
- 사용자 이메일 (email) — varchar
- 비밀번호 (password) — varchar
- 이름 (name) — varchar
- 알림수신여부 (alarm_event) — Boolean
- 회원가입 유형 (login_type) — varchar(kakao, google, service)
- 권한 (role) — USER, ADMIN
- 생성일 (created_at) — Datetime
- 수정일 (updated_at) — Datetime
- 삭제일 (deleted_at) — Boolean(false)
users_goods (UsersGoods)
- id (users_goods_id) — Integer — Primary key — NOT NULL
- id (users_id) — Users — Foreign key → users.id — NOT NULL
- id (goods_id) — Goods — Foreign key → goods.id — NOT NULL
- id (boards_id) — Boards — Foreign key → boards.id — NOT NULL
- 수정한 상품명 (updated_users_goods_name) — varchar
- 수정한 상품가격 (updated_users_goods_price) — Integer
- 상품 총 후원 금액 (users_goods_total_donation) — Integer
- 상품 장바구니 (wish_goods) — Boolean