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