ㄴ
Tables (18)
Activities
- activity_id — BIGINT — Primary key
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- location_name — VARCHAR(100) — NOT NULL
- latitude — DECIMAL(10, 8) — NOT NULL
- longitude — DECIMAL(11, 8) — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- host — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
Blocks
- blocker_id — BIGINT — Primary key — NOT NULL
- blocked_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
Chat_Messages
- message_id — BIGINT — Primary key
- room_id — BIGINT — NOT NULL
- sender_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- sent_at — DATETIME — NOT NULL
Chat_Room_Participants
- room_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
Chat_Rooms
- room_id — BIGINT — Primary key
- created_at — DATETIME — NOT NULL
Chatbot_Conversations
- conversation_id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- user_message — TEXT — NOT NULL
- bot_response — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
Friendships
- user1_id — BIGINT — Primary key — NOT NULL
- user2_id — BIGINT — Primary key — NOT NULL
- status — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Jobs
- job_id — BIGINT — Primary key
- title — VARCHAR(255) — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- salary — VARCHAR(100)
- description — TEXT — NOT NULL
- contact_info — VARCHAR(100) — NOT NULL
- posted_at — DATETIME — NOT NULL
Meetup_Participants
- meetup_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
- status — VARCHAR(10) — NOT NULL
Meetups
- meetup_id — BIGINT — Primary key
- merchant_id — BIGINT
- location_name — VARCHAR(100) — NOT NULL
- meetup_time — DATETIME — NOT NULL
- status — VARCHAR(10) — NOT NULL
- creator_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
Merchant_Categories
- category_id — INT — Primary key
- name — VARCHAR(50) — NOT NULL
Merchants
- merchant_id — BIGINT — Primary key
- name — VARCHAR(100) — NOT NULL
- category_id — INT — NOT NULL
- address — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(10, 8) — NOT NULL
- longitude — DECIMAL(11, 8) — NOT NULL
- phone_number — VARCHAR(20)
- description — TEXT
- created_at — DATETIME — NOT NULL
Notifications
- notification_id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
Reports
- report_id — BIGINT — Primary key
- reporter_id — BIGINT — NOT NULL
- reported_user_id — BIGINT — NOT NULL
- reason — TEXT — NOT NULL
- status — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
Reviews
- review_id — BIGINT — Primary key
- merchant_id — BIGINT — NOT NULL
- user_id — BIGINT
- rating — TINYINT — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
User_Auth
- auth_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → Users.user_id
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
User_Interest_Keywords
- keyword_id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- keyword — VARCHAR(100) — NOT NULL
- weight — FLOAT — NOT NULL
- last_updated — DATE — NOT NULL
Users
- user_id — BIGINT — Primary key
- nickname — VARCHAR(50) — NOT NULL
- birth_year — INT
- gender — VARCHAR(10)
- address — VARCHAR(100)
- status — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL