ㄴ

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