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

initialization_flag

  • initialized — tinyint(1)

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