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