barrier-free

Tables (15)

board

  • no — INT — Primary key — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • subject — VARCHAR(100) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • is_notice — TINYINT — NOT NULL
  • write_date — LONGTEXT — NOT NULL
  • ip — VARCHAR(45) — NOT NULL
  • INDEX — `fk_board_member1_idx`

chat_msg

  • no — INT — Primary key — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • chat_no — INT — Foreign key → chat_room.no — NOT NULL
  • content — LONGTEXT — NOT NULL
  • writedate — DATETIME — NOT NULL
  • INDEX — `fk_chat_msg_member1_idx`
  • INDEX — `fk_chat_msg_chat_room1_idx`

chat_room

  • no — INT — Primary key — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • coo_userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • create_date — DATETIME — NOT NULL
  • INDEX — `fk_chat_room_member1_idx`
  • INDEX — `fk_chat_room_member2_idx`

coordinator

  • no — INT — Primary key — NOT NULL
  • email — VARCHAR(45) — NOT NULL
  • tel — VARCHAR(45) — NOT NULL
  • coo_info — LONGTEXT — NOT NULL
  • link — LONGTEXT — NOT NULL
  • write_date — DATETIME — NOT NULL
  • coo_userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • INDEX — `fk_coordinator_member1_idx`

information

  • contentid — VARCHAR(45) — Primary key — NOT NULL

like_heart

  • no — INT — Primary key — NOT NULL
  • information_no — VARCHAR(100) — Foreign key → information.contentid — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • like — TINYINT — NOT NULL
  • heart — TINYINT — NOT NULL
  • INDEX — `fk_like_heart_information1_idx`
  • INDEX — `fk_like_heart_member1_idx`

member

  • no — INT — Primary key — NOT NULL
  • userid — VARCHAR(45) — NOT NULL
  • userpassword — VARCHAR(45) — NOT NULL
  • date_birth — DATE — NOT NULL
  • date_create — DATETIME — NOT NULL
  • grade_member — INT — NOT NULL
  • grade — INT — NOT NULL
  • question — VARCHAR(200) — NOT NULL
  • answer — VARCHAR(200) — NOT NULL

planner

  • no — INT — Primary key — NOT NULL
  • user_no — INT — Foreign key → member.no — NOT NULL
  • title — INT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • create_date — DATETIME — NOT NULL
  • INDEX — `fk_planner_member1_idx`

planner_location

  • no — INT — Primary key — NOT NULL
  • planner_no — VARCHAR(45) — Foreign key → planner.no — NOT NULL
  • contentid — VARCHAR(45) — NOT NULL
  • order — INT — NOT NULL
  • create_date — DATETIME — NOT NULL
  • edit_date — DATETIME — NOT NULL
  • INDEX — `fk_planner_location_planner1_idx`

planner_member

  • no — INT — Primary key — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • planner_no — INT — Foreign key → planner.no — NOT NULL
  • create_date — DATETIME — NOT NULL
  • join_date — DATETIME — NOT NULL
  • INDEX — `fk_planner_member_planner1_idx`
  • INDEX — `fk_planner_member_member1_idx`

reply_board

  • no — INT — Primary key — NOT NULL
  • board_no — INT — Foreign key → board.no — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • subject — VARCHAR(100) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • write_date — DATETIME — NOT NULL
  • ip — VARCHAR(45) — NOT NULL
  • INDEX — `fk_reply_board_board1_idx`
  • INDEX — `fk_reply_board_member1_idx`

reply_info

  • no — INT — Primary key — NOT NULL
  • information_no — VARCHAR(100) — Foreign key → information.contentid — NOT NULL
  • content — LONGTEXT — NOT NULL
  • score — INT — NOT NULL
  • write_date — DATETIME — NOT NULL
  • ip — DATETIME — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • INDEX — `fk_reply_info_information1_idx`
  • INDEX — `fk_reply_info_member1_idx`

suggestion

  • no — INT — Primary key — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • write_date — DATETIME — NOT NULL
  • ip — VARCHAR(45) — NOT NULL
  • INDEX — `fk_suggestion_member1_idx`

suggestion_reply

  • no — INT — Primary key — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • suggestion_no — VARCHAR(45) — Foreign key → suggestion.no — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • write_date — DATETIME — NOT NULL
  • ip — VARCHAR(45) — NOT NULL
  • INDEX — `fk_suggestion_reply_suggestion1_idx`
  • INDEX — `fk_suggestion_reply_member1_idx`

transportation

  • no — INT — Primary key — NOT NULL
  • route — VARCHAR(45) — NOT NULL
  • content — LONGTEXT — Foreign key → information.contentid — NOT NULL
  • title — VARCHAR(45) — NOT NULL
  • type — INT — NOT NULL
  • link — LONGTEXT — NOT NULL
  • address — VARCHAR(45) — NOT NULL
  • tel — VARCHAR(45) — NOT NULL
  • INDEX — `fk_transportation_information1_idx`