주루마블
테이블 (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