ticcle

Tables (5)

apply (Untitled5)

  • pk (apply_id) — bigint — Primary key — NOT NULL
  • 상품등록시간 (apply_time) — datetime
  • pk (member_id) — bigint — Foreign key → member.pk — NOT NULL
  • pk (product_id) — bigint — Foreign key → product.pk — NOT NULL
  • pk (interest_id) — bigint — Foreign key → interest.pk — NOT NULL

bookmark (Untitled4)

  • pk (bookmark_id) — bigint — Primary key — NOT NULL
  • 북마크생성시간 (book_mark_time) — datetime
  • pk (member_id) — bigint — Foreign key → member.pk — NOT NULL
  • pk (product_id) — bigint — Foreign key → product.pk — NOT NULL
  • pk (interest_id) — bigint — Foreign key → interest.pk — NOT NULL

interest (Untitled3)

  • pk (interest_id) — bigint — Primary key — NOT NULL
  • pk (product_id) — bigint — Foreign key → product.pk — NOT NULL
  • 만기일자 (due_date) — varchar
  • 이자율 (rate) — double

member (Untitled)

  • pk (member_id) — bigint — Primary key — NOT NULL
  • 생년월일 (birth_date) — varchar
  • 생성일시 (created_at) — datetime
  • 이메일 (email) — varchar
  • 멤버여부 (is_member) — varchar
  • 이름 (name) — varchar
  • 비밀번호 (password) — varchar
  • 전화번호 (phone_number) — varchar
  • 주거래은행 (bank_name) — varchar
  • 직업 (job) — varchar
  • 상품타입 (product_type) — varchar

product (Untitled2)

  • pk (product_id) — bigint — Primary key — NOT NULL
  • 예금적금구별 (deposit_or_saving) — varchar
  • 상품 타입 (product_type) — varchar
  • 상품 이름 (product_name) — varchar
  • 상품생성날짜 (product_make_day) — date
  • 예금최소금액 (minimum_amount) — bigint
  • 적금최대금액 (max_limit) — bigint
  • 키워드 (keyword) — varchar
  • 가입방법 (join_way) — varchar
  • 직업전용상품 (job) — varchar
  • 상품설명 (content) — varchar
  • 상품발행은행 (bank_name) — varchar