프로젝트

테이블 (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