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)