babpat

Tables (6)

babpat

  • id (babpat_id) — BIGINT — Primary key — NOT NULL
  • id (restaurant_id) — BIGINT — Foreign key → restaurant.id — NOT NULL
  • member_id (leader_id) — BIGINT — NOT NULL
  • comment — VARCHAR — NOT NULL
  • head_count — INT — NOT NULL
  • pat_date — DATE — NOT NULL
  • pat_time — TIME — NOT NULL
  • babpat_status — VARCHAR — NOT NULL

chat

  • id (chatId) — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_chatting

  • id (chattingID) — BIGINT — Primary key — NOT NULL
  • ctg1 — VARCHAR — NOT NULL
  • ctg2 — VARCHAR — NOT NULL
  • chat — VARCHAR — NOT NULL
  • created_at — DATETIME — NOT NULL
  • id (chatId) — BIGINT — Foreign key → chat.id — NOT NULL

member

  • id (member_id) — BIGINT — Primary key — NOT NULL — auto_increment
  • nickname — VARCHAR — NOT NULL
  • name — VARCHAR — NOT NULL
  • username — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL
  • track — VARCHAR — NOT NULL

participation

  • id (participation_id) — BIGINT — Primary key — NOT NULL
  • id (member_id) — BIGINT — Foreign key → member.id — NOT NULL — auto_increment
  • id (babpat_id) — BIGINT — Foreign key → babpat.id — NOT NULL

restaurant

  • id (restaurant_id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • thumbnail — VARCHAR
  • menu — JSON — NOT NULL
  • category1 — VARCHAR
  • category2 — VARCHAR
  • diet — Boolean — NOT NULL
  • cheap — Boolean — NOT NULL
  • latitude — decimal(18, 15) — NOT NULL
  • longitude — decimal(18, 15) — NOT NULL
  • kakao_link — VARCHAR — NOT NULL