NewCoffeeting
Tables (46)
cafe
- id — long — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- address — varchar(255) — NOT NULL
- url — varchar(255)
- start_time — timestamp
- end_time — timestamp
- phone_number — varchar(17)
- latitude — double
- longtitude — double
- is_active — boolean — NOT NULL
- is_deleted — boolean — NOT NULL
chat_message_history (Untitled20)
- id (Key) — long — Primary key — NOT NULL
- chatroom_id (Key2) — long — Foreign key → chatroom.id — NOT NULL
- sender (Field) — enum('MEMBER', 'BOT') — NOT NULL
- message (Field2) — text — NOT NULL
- node_key (Field3) — varchar(50)
chat_scenario_history (Untitled21)
- id (Key) — long — Primary key — NOT NULL
- chatroom_id (Key2) — long — Foreign key → chatroom.id — NOT NULL
- node_key (Field) — varchar(50) — NOT NULL
- option_label (Field2) — varchar(100)
- next_node_key (Field3) — varchar(50)
chat_scenario_node (Untitled19)
- id (Key) — long — Primary key — NOT NULL
- chatbot_id (Key2) — long — Foreign key → chatbot.id — NOT NULL
- node_key (Field) — varchar(50) — NOT NULL
- message (Field2) — text — NOT NULL
- next_node_key (Field3) — varchar(50)
- next_node_options (Field4) — json
- message_type (Field5) — enum('STATIC', 'AI') — NOT NULL
- ai_feature_type (Field6) — enum('PROFILE_FEEDBACK')
chatbot (Untitled9)
- id (Key) — long — Primary key — NOT NULL
- title (Field) — varchar(100) — NOT NULL
- description (Field2) — varchar(100) — NOT NULL
- image_url (Field3) — varchar(1000)
- chat_type (Field4) — ENUM('SCENARIO', 'FREE') — NOT NULL
- feature_type (Field6) — ENUM('ROASTME') — NOT NULL
- start_node_key (Field5) — varchar(50) — NOT NULL
chatroom (Untitled18)
- id (Key) — long — Primary key — NOT NULL
- chatbot_id (Key2) — long — Foreign key → chatbot.id — NOT NULL
- member_id (Field2) — long — NOT NULL
- current_node_key (Field) — varchar(50) — NOT NULL
community_question (Untitled6)
- id (Key) — long — Primary key — NOT NULL
- member_id (id) — long — Foreign key → member.id — NOT NULL
- question_content (Field) — text — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
- is_deleted (Field4) — boolean — NOT NULL
community_question_answer (Untitled)
- id (Key2) — long — Primary key — NOT NULL
- answer_member_id (id) — long — Foreign key → member.id — NOT NULL
- question_id (Key) — long — Foreign key → community_question.id — NOT NULL
- answer_content (Field) — text — NOT NULL
community_question_answer_like (Untitled7)
- id (Key) — long — Primary key — NOT NULL
- member_id (id) — long — Foreign key → member.id — NOT NULL
- answer_id (Key2) — long — Foreign key → community_question_answer.id — NOT NULL
connect (Untitled28)
- id (Key) — long — Primary key — NOT NULL
- discover_id (Key2) — long — Foreign key → discover.id — NOT NULL
- male_member_id (id) — long — Foreign key → member.id — NOT NULL
- female_member_id (id2) — long — Foreign key → member.id — NOT NULL
- status (Field) — enum(PENDING, ACCEPT, EXPIRED) — NOT NULL
connect_ticket (Untitled29)
- id (Key) — long — Primary key — NOT NULL
- connect_id (Key2) — long — Foreign key → connect.id — NOT NULL
- ticket_id (id) — long — Foreign key → ticket.id — NOT NULL
contacts (Untitled2)
- id — long — Primary key — NOT NULL
- member_id (id2) — long — Foreign key → member.id — NOT NULL
- phoneNumber (Field) — varchar(20) — NOT NULL
discover (Untitled27)
- id (Key) — long — Primary key — NOT NULL
- request_member_id (id) — long — Foreign key → member.id — NOT NULL
- request_like (Field2) — enum(PENDING, ACCEPT, REJECT, EXPIRED) — NOT NULL
- requested_at (Field6) — datetime(6)
- response_member_id (id2) — long — Foreign key → member.id — NOT NULL
- response_like (Field4) — enum(PENDING, ACCEPT, REJECT, EXPIRED) — NOT NULL
- responsed_at (Field5) — datetime(6)
- status (Field) — enum(WAITING_FOR_REQUEST, WAITING_FOR_RESPONSE, ACCEPTED, REJECTED, EXPIRED)
- category (Field3) — enum(MANAGER, LOVE_ATTITUDE)
discover_exclude (Untitled4)
- id (Key) — long — Primary key — NOT NULL
- excluder_member_id (id) — long — Foreign key → member.id — NOT NULL
- excluded_member_id (id2) — long — Foreign key → member.id — NOT NULL
- exclude_type (Field) — enum — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
- is_deleted (Field4) — boolean — NOT NULL
discover_reject_reason (Untitled17)
- id (Key) — long — Primary key — NOT NULL
- rejecter_member_id (Field) — long — NOT NULL
- rejected_member_id (Field2) — long — NOT NULL
- discover_id (Field3) — long — NOT NULL
- selected_reason (Field5) — JSON
- custom_reason (Field4) — TEXT
document (Untitled14)
- id (Key) — long — Primary key — NOT NULL
- verify_type (Field4) — enum('EDUCATION',. 'COMPANY') — NOT NULL
- name (Field5) — varchar(50) — NOT NULL
- file_url (Field2) — varchar(255) — NOT NULL
- verification_status (Field) — enum — NOT NULL
- verified_at (Field3) — timestamp
- company_scale (Field6) — enum
- education_scale (Field7) — enum
email (Untitled13)
- id (Key) — long — Primary key — NOT NULL
- verify_type (Field6) — enum('EDUCATION',. 'COMPANY') — NOT NULL
- name (Field7) — varchar(50) — NOT NULL
- domain (Field) — varchar(100) — NOT NULL
- verified_at (Field2) — timestamp — NOT NULL
- comany_scale (Field3) — enum — NOT NULL
- education_scale (Field4) — enum — NOT NULL
- verifications_staus (Field5) — enum — NOT NULL
integrate_member (Untitled10)
- id (Key) — long — Primary key — NOT NULL
- member_id — long — Foreign key → member.id — NOT NULL
- ci (Field) — varchar(88) — NOT NULL
- kakao_email (Field2) — varchar(255)
- phone_number (Field3) — varchar(17) — NOT NULL
- login_type (Field4) — ENUM('KAKAO') — NOT NULL
- created_at (Field5) — timestamp — NOT NULL
- updated_at (Field6) — timestamp — NOT NULL
- is_deleted (Field7) — boolean — NOT NULL
legacy_discover (deprecated) (discover)
- id — long — Primary key — NOT NULL
- request — enum(PENDING, ACCEPT, REJECT) — NOT NULL
- request_type — enum(REQUEST, EXCLUSIVE)
- request_at — timestamp — NOT NULL
- response — enum(PENDING, ACCEPT, REJECT) — NOT NULL
- response_at — timestamp — NOT NULL
- description — varchar(100)
- request_user_id — long — Foreign key → member.id — NOT NULL
- response_user_id — long — Foreign key → member.id — NOT NULL
- request_user_ticket — long — Foreign key → ticket.id — NOT NULL
- response_user_ticket — long — Foreign key → ticket.id — NOT NULL
- create_manager_id — long — Foreign key → member.id — NOT NULL
- is_deleted — boolean — NOT NULL
love_attitude_discover_request_log (Untitled30)
- id (Key) — long — Primary key — NOT NULL
- member_id (Field) — long — NOT NULL
- requested_at (Field2) — datetime(6) — NOT NULL
- status (Field3) — enum(PENDING, ACCEPT, REJECT, EXPIRED) — NOT NULL
love_attitude_question (Untitled24)
- id (Key) — long — Primary key — NOT NULL
- order_no (Field3) — int — NOT NULL
- content (Field) — varchar(200) — NOT NULL
- question_type (Field2) — enum() — NOT NULL
love_attitude_response (Untitled25)
- id (Key) — long — Primary key — NOT NULL
- member_id (id) — long — Foreign key → member.id — NOT NULL
- submitted_at (Field) — timestamp — NOT NULL
- created_at (Field2) — timestamp — NOT NULL
- updated_at (Field3) — timestamp — NOT NULL
- is_deleted (Field4) — boolean — NOT NULL
love_attitude_response_detail (Untitled26)
- id (Key) — long — Primary key — NOT NULL
- love_attitude_question_id (Key2) — long — Foreign key → love_attitude_question.id — NOT NULL
- love_attitude_response_id (Key3) — long — Foreign key → love_attitude_response.id — NOT NULL
- answer_num (Field) — int — NOT NULL
meet
- id — long — Primary key — NOT NULL
- meet_datetime
- cafe_id — long — Foreign key → cafe.id — NOT NULL
- connect_id (Key) — long — Foreign key → connect.id
- discover_id — long — Foreign key → legacy_discover (deprecated).id
- male_user_id — long — Foreign key → member.id — NOT NULL
- female_user_id — long — Foreign key → member.id — NOT NULL
- male_confirm — enum(PENDING,ACCEPT,REJECT) — NOT NULL
- female_confirm — enum(PENDING, ACCEPT, REJECT) — NOT NULL
- status — enum(MATCHED, CANCELED, NOSHOW, COMPLETED)
- description — varchar(100)
- is_deleted — boolean
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
member
- id — long — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- phone_number — varchar(17) — NOT NULL
- gender — enum(MALE, FEMALE) — NOT NULL
- birth_year — SMALL INT — NOT NULL
- point — int — NOT NULL
- role — enum(ADMIN,MANAGER, USER) — NOT NULL
- referral_code — archar(10) — NOT NULL
- push_token — varchar(100)
- is_on_hold — boolean — NOT NULL
- is_on_withdraw — boolean — NOT NULL
- is_deleted — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- eligibility — enum('AVAILABLE','UNAVAILABLE','PENDING','REVIEWING') — NOT NULL
- eligibility_time — datetime(6)
- is_pledged — bit(1) — NOT NULL
- receive_feedback — bit(1) — NOT NULL
- is_contacts_blocked (Field) — bit(1) — NOT NULL
- is_same_company_blocked (Field2) — bit(1) — NOT NULL
- is_receive_only (Field3) — bit(1) — NOT NULL
member_activity (Untitled5)
- id (Key) — long — Primary key — NOT NULL
- create_at (Field3) — timestamp — Primary key
- member_id (Field) — long — NOT NULL
- activity_date (Field2) — DATE — NOT NULL
- create_at (Field4) — timestamp — NOT NULL
- update_at (Field5) — timestamp — NOT NULL
- is_deleted (Field6) — boolean — NOT NULL
member_discover_status (Untitled16)
- id (Key) — long — Primary key — NOT NULL
- member_id (id) — long — Foreign key → member.id — NOT NULL
- preferred_day (Field) — enum
- is_weekly_temporary_unavailable (Field2) — boolean — NOT NULL
- is_region_unavailable (Field3) — boolean — NOT NULL
- is_ideal_unavailable (Field4) — boolean — NOT NULL
- is_profile_unavailable (Field5) — boolean — NOT NULL
member_ideal_note (Untitled31)
- id (Key) — long — Primary key — NOT NULL
- member_id (id) — long — Foreign key → member.id — NOT NULL
- is_ideal (Field) — boolean — NOT NULL
- content (Field2) — text — NOT NULL
- created_at (Field3) — timestamp — NOT NULL
- updated_at (Field4) — timestamp — NOT NULL
- is_deleted (Field5) — booelan — NOT NULL
member_photo
- id — long — Primary key — NOT NULL
- member_profile_id — long — Foreign key → member_profile.id — NOT NULL
- is_profile_photo — long — NOT NULL
- photo_url — long — NOT NULL
- sequence — int — NOT NULL
member_profile
- id (Key) — long — Primary key — NOT NULL
- member_id — long — Foreign key → member.id — NOT NULL
- height — int — NOT NULL
- income — enum — NOT NULL
- residence_area — string — NOT NULL
- company_location — string — NOT NULL
- mbti_ei — string — NOT NULL
- mbti_sn — string — NOT NULL
- mbti_tf — string — NOT NULL
- mbti_jp — string — NOT NULL
- religion (religoin) — enum — NOT NULL
- drink_pattern — enum — NOT NULL
- smoke_pattern — enum — NOT NULL
- life_pattern — enum — NOT NULL
- relationship_goal — enum — NOT NULL
- education — enum — NOT NULL
member_profile_progress (Untitled12)
- id (Key) — long — Primary key — NOT NULL
- member_id (id) — long — Foreign key → member.id — NOT NULL
- is_profile_filled (Field) — boolean — NOT NULL
- is_important_value_filled (Field2) — boolean — NOT NULL
- is_company_verified (Field3) — boolean — NOT NULL
- is_education_verfied (Field4) — boolean — NOT NULL
member_profile_relationship_goal
- id — long — Primary key — NOT NULL
- member_profile_id — long — Foreign key → member_profile.id — NOT NULL
- relationshipGoal — enum — NOT NULL
member_relationship_value
- id — long — Primary key — NOT NULL
- member_id — long — Foreign key → member.id — NOT NULL
- loveQuestion — varchar(350) — NOT NULL
- careerQuestion — varchar(350) — NOT NULL
- lifeQuestion — varchar(350) — NOT NULL
member_review_record (Untitled15)
- id (Key) — long — Primary key — NOT NULL
- member_id (id) — long — Foreign key → member.id — NOT NULL
- eligibility (Field2) — enum — NOT NULL
- reviewed_at (Field3) — timestamp — NOT NULL
- isProfileInfoRejected (Field) — boolean — NOT NULL
- isRelationshipValueRejected (Field4) — boolean — NOT NULL
- isJobVerificationRejected (Field5) — boolean — NOT NULL
- profileInfoReason (Field6) — varchar(255) — NOT NULL
- relationshipValueReason (Field7) — varchar(255) — NOT NULL
- jobVerificationReason (Field8) — varchar(255) — NOT NULL
member_verification (Untitled3)
- id (Key) — long — Primary key — NOT NULL
- member_id (id) — long — Foreign key → member.id — NOT NULL
- phone_number (Field) — varchar(17) — NOT NULL
- gender (Field2) — ENUM('MALE', 'FEMALE') — NOT NULL
- name (Field3) — varchar(50) — NOT NULL
- birth_year (Field4) — SMALL INT — NOT NULL
- verified_at (Field5) — timestamp — NOT NULL
- ci (Field6) — varchar(88) — NOT NULL
notification_alimtalk_history (Untitled22)
- id (Key) — long — Primary key — NOT NULL
- member_id (Field) — long — NOT NULL
- template_code (Field2) — varchar(30) — NOT NULL
- status (Field3) — enum('NOT_QUEUED', 'QUEUED', 'FAILED', 'SUCCEEDED') — NOT NULL
notification_push_history (CopyOfUntitled22)
- id (Key) — long — Primary key — NOT NULL
- member_id (Field2) — long — NOT NULL
- title (Field) — varchar(200) — NOT NULL
- message (Field3) — varchar(200) — NOT NULL
- status (Field4) — enum('NOT_QUEUED', 'QUEUED', 'FAILED', 'SUCCEEDED') — NOT NULL
- is_opened (Field5) — boolean — NOT NULL
- opened_at (Field6) — timestamp
order
- id — long — Primary key — NOT NULL
- user_id — long — Foreign key → member.id — NOT NULL
- point_transaction — long — Foreign key → point_transaction.id
- used_point — int — NOT NULL
- product — long — NOT NULL
- ticket_amount — int — NOT NULL
- receipt — varchar(100)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
ota_bundle_version (Untitled8)
- id (Key) — long — Primary key — NOT NULL
- target_app_version (Field) — varchar(20) — NOT NULL
- ota_version (Field2) — varchar(20) — NOT NULL
- bundle_path (Field3) — varchar(100) — NOT NULL
- os_type (Field12) — enum(IOS, ANDROID) — NOT NULL
- note (Field4) — text
- is_on_deploy (Field5) — boolean — NOT NULL
- required (Field6) — boolean — NOT NULL
- is_rollback_enabled (Field7) — boolean — NOT NULL
- rollback_version_id (Field8) — long
- created_at (Field9) — timestamp — NOT NULL
- updated_at (Field10) — timestamp — NOT NULL
- is_deleted (Field11) — boolean
payment
- id — long — Primary key — NOT NULL
- order_id — long — Foreign key → order.id — NOT NULL
- type — enum(APP_STORE, PLAY_STORE, TOSS) — NOT NULL
- transaction_id — varchar(100) — NOT NULL
- is_refunded — boolean
- refund_reason — boolean
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
point_coupon
- id — long — Primary key — NOT NULL
- code — varchar(100) — NOT NULL
- point — long — NOT NULL
- quantity — int — NOT NULL
- used_count — int — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
point_transaction
- id — long — Primary key — NOT NULL
- user_id — long — Foreign key → member.id — NOT NULL
- coupon_id — long — Foreign key → point_coupon.id
- amount — int — NOT NULL
- balance — int — NOT NULL
- type — enum(INCREASE, DECREASE) — NOT NULL
- description — varchar(100)
- created_at — timestamp — NOT NULL
- updated_at (updated_date) — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
- create_manager_id (Field) — long — NOT NULL
prompts (Untitled23)
- id (Key) — long — Primary key — NOT NULL
- name (Field) — varchar(200) — NOT NULL
- content (Field2) — TEXT — NOT NULL
- created_at (Field3) — timestamp — NOT NULL
- updated_at (Field4) — timestamp — NOT NULL
- is_deleted (Field5) — boolean — NOT NULL
referral
- id — long — Primary key — NOT NULL
- referrer_id — long — Foreign key → member.id — NOT NULL
- referred_id (referrered_id) — long — Foreign key → member.id — NOT NULL
- point_transaction — long — Foreign key → point_transaction.id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- is_deleted — boolean — NOT NULL
ticket
- id — long — Primary key — NOT NULL
- user_id — long — Foreign key → member.id — NOT NULL
- order_id — long — Foreign key → order.id — NOT NULL
- is_used — boolean — NOT NULL
- description — varchar(100)
- create_at — timestamp — NOT NULL
- update_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
verification (Untitled11)
- id (Key) — long — Primary key — NOT NULL
- member_id (id) — long — Foreign key → member.id — NOT NULL
- verify_method (Field2) — enum — NOT NULL
- created_at (Field3) — timestamp — NOT NULL
- updated_at (Field4) — timestamp — NOT NULL
- is_deleted (Field5) — boolean — NOT NULL
- email_id (Key2) — long — Foreign key → email.id — NOT NULL
- document_id (Key3) — long — Foreign key → document.id — NOT NULL