주루마블

테이블 (6)

drink

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(30)
  • type — VARCHAR(10)
  • product_name — VARCHAR(50)
  • alcoholic_beverage — VARCHAR(100)
  • raw_material — VARCHAR(255)
  • capacity — INTEGER
  • manufacture_address — VARCHAR(255)
  • price — INTEGER
  • image — VARCHAR(255)

users

  • id — BIGINT — 기본 키 — NOT NULL
  • nickname — VARCHAR(20)
  • email — VARCHAR(55)
  • password — VARCHAR(15)
  • image_url — VARCHAR(255)
  • age — INTEGER
  • gender — VARCHAR(6)
  • mbti — VARCHAR(4)
  • provider_type — VARCHAR(10)
  • provider_id — VARCHAR(255)
  • created_date — TIMESTAMP
  • modified_date — TIMESTAMP
  • modified_mbti_date — TIMESTAMP
  • deleted_date — TIMESTAMP

vote

  • id — BIGINT — 기본 키 — NOT NULL
  • posted_user_id — BIGINT — NOT NULL
  • title — VARCHAR(55)
  • detail — VARCHAR(255)
  • filtered_age — VARCHAR(10)
  • filtered_gender — VARCHAR(6)
  • filtered_mbti — VARCHAR(4)
  • vote_type — VARCHAR(6)
  • created_date — TIMESTAMP
  • modified_date — TIMESTAMP

vote_content

  • id — BIGINT — 기본 키 — NOT NULL
  • vote_id — BIGINT — NOT NULL
  • imageA — VARCHAR(255)
  • imageB — VARCHAR(255)
  • titleA — VARCHAR(55)
  • titleB — VARCHAR(55)

vote_drink_content

  • id — BIGINT — 기본 키 — NOT NULL
  • vote_id — BIGINT — NOT NULL
  • drink_a_id — BIGINT — NOT NULL
  • drink_b_id — BIGINT — NOT NULL
  • drink_a_name — VARCHAR(30)
  • drink_a_type — VARCHAR(10)
  • drink_b_name — VARCHAR(30)
  • drink_b_type — VARCHAR(10)

vote_result

  • id — BIGINT — 기본 키 — NOT NULL
  • vote_id — BIGINT — NOT NULL
  • voted_user_id — BIGINT — NOT NULL
  • choice — VARCHAR(2)
  • created_date — TIMESTAMP
  • modified_date — TIMESTAMP