프로젝트
테이블 (7)
ad_marker_table (11)
- store_id (Key2) — int(11) — 외래 키 → kakao server.store_id — NOT NULL
- day (Field) — int(11) — NOT NULL
- text (Field2) — varchar(40) — NOT NULL
app_chat_table (Untitled5)
- chat_no (Key) — auto_increment — 기본 키 — NOT NULL
- chat (Field) — text — NOT NULL
- stamp (Field2) — integer — NOT NULL
- type (Field3) — integer — NOT NULL
app_matching_table (Untitled6)
- store_id (Key2) — int(11) — 외래 키 → kakao server.store_id — NOT NULL
- store_name (Field) — text — NOT NULL
- lat (Field2) — real — NOT NULL
- lng (Field3) — real — NOT NULL
- distance (Field4) — text
- address (Field5) — text
- phone (Field6) — text
- category (Field7) — text
- match_time (Field8) — text
block_table (Untitled)
- member_id (Key) — auto_increment — 기본 키 — NOT NULL
- op_member_id (Field) — int(11) — NOT NULL
- member_id (Key2) — int(11) — 외래 키 → member_table.member_id — NOT NULL
kakao server (Untitled4)
- store_id (Key) — int — 기본 키 — NOT NULL
- and so on (Field)
match_table (Untitled3)
- match_no (Key) — int(11) — 기본 키 — NOT NULL
- store_id (Key3) — int(11) — 외래 키 → kakao server.store_id — NOT NULL
- member_id (Field2) — int(11) — NOT NULL
- member_token (Field3) — varchar(255) — NOT NULL
- member_id (Key2) — int(11) — 외래 키 → member_table.member_id — NOT NULL
member_table (Untitled2)
- member_id (Key) — int(11) — 기본 키 — NOT NULL
- member_phone (Field) — varchar(12) — NOT NULL
- member_password (Field2) — varchar(16) — NOT NULL
- Field3