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`