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