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