GIVU&TAKE ERD
Tables (21)
addresses
- address_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- address_name — varchar(8) — NOT NULL
- bname — varchar(10) — NOT NULL
- bname1 — varchar(10) — NOT NULL
- building_name — varchar(20) — NOT NULL
- detail_address — varchar(50) — NOT NULL
- is_apartment — bit(1) — NOT NULL
- is_deleted — bit(1) — NOT NULL
- is_reprentative — bit(1) — NOT NULL
- jibun_address — varchar(50) — NOT NULL
- road_address — varchar(50) — NOT NULL
- zone_code — varchar(5) — NOT NULL
- user_idx — int(11) — Foreign key → users.user_idx — NOT NULL
- region_idx — int(11) — Foreign key → region.region_idx — NOT NULL
answer
- answer_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- answer_content — varchar(1000) — NOT NULL
- admin_idx — int(11) — Foreign key → users.user_idx
- qna_idx — int(11) — Foreign key → qna.qna_idx
business_registration_certificates
- certificate_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- file_path — varchar(2048) — NOT NULL
- user_idx — int(11) — Foreign key → users.user_idx — NOT NULL
cards
- card_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- card_cvc — varchar(3) — NOT NULL
- card_company — varchar(30) — NOT NULL
- card_expired_date — date — NOT NULL
- card_number — varchar(19) — NOT NULL
- card_password — varchar(60) — NOT NULL
- is_deleted — bit(1) — NOT NULL
- is_representative — bit(1) — NOT NULL
- user_idx — int(11) — Foreign key → users.user_idx — NOT NULL
carts
- cart_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- amount — int(11)
- gift_idx — int(11) — Foreign key → gifts.gift_idx
- user_idx — int(11) — Foreign key → users.user_idx
categories
- category_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- category_name — varchar(30) — NOT NULL
- category_type — int(11) — NOT NULL
cheer_comments
- comment_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- comment_content — varchar(400) — NOT NULL
- is_deleted — bit(1) — NOT NULL
- funding_idx — int(11) — Foreign key → fundings.funding_idx — NOT NULL
- user_idx — int(11) — Foreign key → users.user_idx — NOT NULL
experience_village
- experience_village_idx — int(11) — Primary key — NOT NULL
- experience_village_address — varchar(100) — NOT NULL
- experience_village_division — varchar(100) — NOT NULL
- experience_village_homepage_url — varchar(50) — NOT NULL
- experience_village_name — varchar(30) — NOT NULL
- experience_village_phone — varchar(13) — NOT NULL
- experience_village_program — varchar(800) — NOT NULL
- region_idx — int(11) — Foreign key → region.region_idx — NOT NULL
funding_participants
- participant_idx — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- card_number — varchar(20)
- funding_fee — int(11) — NOT NULL
- payment_method — varchar(255) — NOT NULL
- funding_idx — int(11) — Foreign key → fundings.funding_idx — NOT NULL
- user_idx — int(11) — Foreign key → users.user_idx — NOT NULL
funding_reviews
- review_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- review_content — varchar(6000) — NOT NULL
- review_content_image — varchar(2048)
- funding_idx — int(11) — Foreign key → fundings.funding_idx — NOT NULL
fundings
- funding_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- end_date — date — NOT NULL
- funding_content — varchar(6000)
- funding_content_image — varchar(2048)
- funding_thumbnail — varchar(2048)
- funding_title — varchar(30) — NOT NULL
- funding_type — char(1) — NOT NULL
- goal_money — int(11) — NOT NULL
- is_deleted — bit(1) — NOT NULL
- start_date — date — NOT NULL
- state — tinyint(4) — NOT NULL
- total_money — int(11) — NOT NULL
- corporation_idx — int(11) — Foreign key → users.user_idx — NOT NULL
gift_review_liked
- like_idx — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- review_idx — int(11) — Foreign key → gift_reviews.review_idx
- user_idx — int(11) — Foreign key → users.user_idx
gift_reviews
- review_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- is_delete — bit(1)
- liked_count — int(11)
- review_content — varchar(6000) — NOT NULL
- review_image — varchar(2048)
- gift_idx — int(11) — Foreign key → gifts.gift_idx
- order_idx — bigint(20) — Foreign key → orders.order_idx
- user_idx — int(11) — Foreign key → users.user_idx
gifts
- gift_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- amount — int(11)
- gift_content — varchar(6000)
- gift_content_image — varchar(2048)
- gift_name — varchar(60) — NOT NULL
- gift_thumbnail — varchar(2048)
- is_delete — bit(1)
- price — int(11) — NOT NULL
- category_idx — int(11) — Foreign key → categories.category_idx
- corporation_idx — int(11) — Foreign key → users.user_idx
orders
- order_idx — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- amount — int(11) — NOT NULL
- card_number — varchar(20)
- payment_method — varchar(255) — NOT NULL
- price — int(11) — NOT NULL
- status — enum('DELIVERED','DELIVERY','PROCESSED','REFUDING','REFUNDED','SHIPPED')
- gift_idx — int(11) — Foreign key → gifts.gift_idx
- user_idx — int(11) — Foreign key → users.user_idx
qna
- qna_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- qna_content — varchar(1000) — NOT NULL
- qna_title — varchar(50) — NOT NULL
- user_idx — int(11) — Foreign key → users.user_idx
region
- region_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- sido — varchar(10) — NOT NULL
- sigungu — varchar(10) — NOT NULL
user_view_logs
- log_idx — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- act_enum — enum('CREATE','DELETE','READ','UPDATE')
- content_idx — int(11) — NOT NULL
- content_type — enum('EXPERIENCE_VILLAGE','FUNDING','GIFT')
- user_idx — int(11) — Foreign key → users.user_idx
users
- user_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- birth — date
- email — varchar(255) — NOT NULL
- is_male — bit(1)
- is_social — bit(1) — NOT NULL
- is_withdraw — bit(1) — NOT NULL
- landline_phone — varchar(255)
- mobile_phone — varchar(255)
- name — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- profile_image_url — varchar(255)
- roles — enum('ROLE_ADMIN','ROLE_CLIENT','ROLE_CORPORATION','ROLE_CORPORATIONYET') — NOT NULL
- social_serial_num — varchar(255)
- social_type — enum('GOOGLE')
- region_idx — int(11) — Foreign key → region.region_idx
wish
- wish_idx — int(11) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- modified_date — datetime(6) — NOT NULL
- gift_idx — int(11) — Foreign key → gifts.gift_idx
- user_idx — int(11) — Foreign key → users.user_idx