MATE

Tables (7)

member

  • member_id — bigint — Primary key
  • create_date — datetime(6)
  • update_date — datetime(6)
  • area — varchar(50)
  • auth — varchar(10)
  • delete_date — datetime(6)
  • department — varchar(255)
  • email — varchar(255)
  • is_member — tinyint
  • is_removed — tinyint
  • member_name — varchar(255)
  • password — varchar(255)
  • phone_number — varchar(11)
  • profile_image — varchar(255)
  • student_number — varchar(255)

member_timetable

  • member_timetable_id — bigint — Primary key
  • member_id — bigint — Foreign key → member.member_id
  • day_code — varchar(1) — NOT NULL

passenger

  • passenger_id — bigint — Primary key
  • member_id — bigint — Foreign key → member.member_id
  • ticket_id — bigint — Foreign key → ticket.ticket_id
  • create_date — datetime(6)
  • update_date — datetime(6)
  • is_cancel — tinyint(1)

question_board

  • question_board_id — bigint — Primary key
  • member_id — bigint — Foreign key → member.member_id
  • create_date — datetime(6)
  • update_date — datetime(6)
  • content — varchar(255)
  • title — varchar(255)
  • writer_email — varchar(255)
  • writer_student_id — varchar(255)

report_board

  • report_board_id — bigint — Primary key
  • member_id — bigint — Foreign key → member.member_id
  • create_date — datetime(6)
  • update_date — datetime(6)
  • content — varchar(255)
  • report_student_id — varchar(255)
  • writer_email — varchar(255)
  • writer_student_id — varchar(255)

ticket

  • ticket_id — bigint — Primary key
  • create_date — datetime(6)
  • update_date — datetime(6)
  • boarding_place — varchar(255)
  • day_status — varchar(255)
  • end_area — varchar(50)
  • kakao_open_chat_title — varchar(255)
  • open_chat_url — varchar(255)
  • recruit_person — int
  • start_area — varchar(50)
  • start_dtime — varchar(255)
  • status — varchar(8)
  • ticket_price — bigint
  • ticket_type — varchar(255)
  • member_id — bigint

withdrawal

  • withdrawal_id — bigint — Primary key
  • content — varchar(255)