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