LingSum

Tables (8)

AIFriend (AI친구)

  • id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • gender (Field) — ENUM('Male','Female')
  • description — JSON
  • image — FILE
  • prompt — TEXT
  • created_at — DATETIME

ChatRoom (채팅방)

  • id — INT — Primary key
  • user_id (id2) — INT — Foreign key → User.id
  • ai_friend_id (id3) — INT — Foreign key → AIFriend.id
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted (Field2) — BOOLEAN
  • is_reported — BOOLEAN
  • report_detail — TEXT

History (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • chatroom_id (id) — INT — Foreign key → ChatRoom.id
  • summary (Field) — TEXT
  • updated_at (Field2) — DATETIME
  • is_deleted (Field3) — BOOLEAN

Like (좋아요)

  • id — INT — Primary key
  • user_id — INT — Foreign key → User.id
  • ai_friend_id — INT — Foreign key → AIFriend.id
  • like_dislike — ENUM('like','dislike')
  • is_matched — BOOLEAN
  • is_chatted — BOOLEAN
  • created_at — DATETIME — NOT NULL
  • matched_at — DATETIME

Message (메세지)

  • id — BIGINT — Primary key
  • chatroom_id — INT — Foreign key → ChatRoom.id
  • sender_type — ENUM('user', 'ai') — NOT NULL
  • content — TEXT — NOT NULL
  • fixed_content — TEXT
  • translated_content — TEXT
  • created_at — DATETIME
  • is_deleted — BOOLEAN

Payments (결제)

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.id
  • plan_id — INT — Foreign key → Plan.id — NOT NULL
  • purchase_token — VARCHAR(128)
  • purchase_date — DATETIME
  • expiration_date — DATETIME
  • status — ENUM
  • cancel_reason — VARCHAR(255)
  • transaction_id — VARCHAR(100)
  • promotion_code — VARCHAR(200)

Plan (구독)

  • id — INT — Primary key — NOT NULL
  • plan_name — VARCHAR(128)
  • price — DEMICAL(6, 3)

User (유저)

  • id — INT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • fullname — VARCHAR(100)
  • nickname — VARCHAR(100)
  • birth — DATE
  • gender — ENUM('Male','Female')
  • preferred_gender — ENUM('Male','Female','Both')
  • intro — TEXT
  • job — VARCHAR(100)
  • MBTI — VARCHAR(10)
  • lifestyle — JSON
  • interests — TEXT
  • social_id — VARCHAR(255)
  • provider — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN
  • is_active — BOOLEAN