readdam
Tables (33)
alert
- alert_id — INT
- content — TEXT
- is_checked — TINYINT(1)
- sender_name — VARCHAR(100)
- username — VARCHAR(255)
- type — VARCHAR(50)
banner
- banner_id — INT
- title — VARCHAR(255)
- style — VARCHAR(50)
- img — VARCHAR(255)
- is_show — TINYINT(1)
- seq — INT
- title_text — VARCHAR(255)
- content — TEXT
- btn1_name — VARCHAR(100)
- btn1_link — VARCHAR(255)
- btn1_color — VARCHAR(20)
- btn1_is_show — TINYINT(1)
- btn2_name — VARCHAR(100)
- btn2_link — VARCHAR(255)
- btn2_color — VARCHAR(20)
- btn2_is_show — TINYINT(1)
- back_color — VARCHAR(20)
- text_color — VARCHAR(20)
book
- book_isbn — VARCHAR(20)
- ranking — INT
- title — VARCHAR(255)
- publisher — VARCHAR(255)
- pub_date — DATETIME
- writer — VARCHAR(255)
- review_cnt — INT
- view_cnt — INT
- rating — DECIMAL(3,2)
- book_img — VARCHAR(255)
- book_intro — TEXT
book_like
- like_id — INT
- username — VARCHAR(255)
- date — DATETIME
- book_isbn — VARCHAR(20)
book_review
- book_review_id — INT
- book_isbn — VARCHAR(20)
- rating — DECIMAL(3,2)
- comment — TEXT
- reg_time — DATETIME
- username — VARCHAR(255)
- is_hide — TINYINT(1)
class
- class_id — INT
- leader_username — INT
- title — VARCHAR(255)
- short_intro — VARCHAR(255)
- tag1 — VARCHAR(50)
- tag2 — VARCHAR(50)
- tag3 — VARCHAR(50)
- min_person — INT
- max_person — INT
- main_img — VARCHAR(255)
- class_intro — TEXT
- leader_img — VARCHAR(255)
- leader_intro — TEXT
- round1_date — DATETIME
- round1_place_name — VARCHAR(255)
- round1_place_loc — VARCHAR(255)
- round1_img — VARCHAR(255)
- round1_content — TEXT
- round1_bookname — VARCHAR(255)
- round1_bookimg — VARCHAR(255)
- round1_bookwriter — VARCHAR(255)
- round2_date — DATETIME
- round2_place_name — VARCHAR(255)
- round2_place_loc — VARCHAR(255)
- round2_img — VARCHAR(255)
- round2_content — TEXT
- round2_bookname — VARCHAR(255)
- round2_bookimg — VARCHAR(255)
- round2_bookwriter — VARCHAR(255)
- round3_date — DATETIME
- round3_place_name — VARCHAR(255)
- round3_place_loc — VARCHAR(255)
- round3_img — VARCHAR(255)
- round3_content — TEXT
- round3_bookname — VARCHAR(255)
- round3_bookimg — VARCHAR(255)
- round3_bookwriter — VARCHAR(255)
- round4_date — DATETIME
- round4_place_name — VARCHAR(255)
- round4_place_loc — VARCHAR(255)
- round4_img — VARCHAR(255)
- round4_content — TEXT
- round4_bookname — VARCHAR(255)
- round4_bookimg — VARCHAR(255)
- round4_bookwriter — VARCHAR(255)
class_like
- like_id — INT
- username — VARCHAR(255)
- date — DATETIME
- class_id — INT
class_qna
- class_qna_id — INT
- class_id — INT
- username — VARCHAR(255)
- content — TEXT
- answer — TEXT
- reg_date — DATETIME
- is_secret — TINYINT(1)
- is_hide — TINYINT(1)
class_review
- class_review_id — INT
- class_id — INT
- username — VARCHAR(255)
- content — TEXT
- reg_date — DATETIME
- is_hide — TINYINT(1)
- rating — INT
- img — VARCHAR(255)
- is_hide — TINYINT(1)
class_user
- class_id — INT
- username — VARCHAR(255)
- join_date — DATETIME
- left_date — DATETIME
event
- event_id — INT
- title — VARCHAR(255)
- s_time — DATETIME
- e_time — DATETIME
inquiry
- inquiry_id — INT
- title — VARCHAR(255)
- content — TEXT
- answer — TEXT
- reg_date — DATETIME
- status — ENUM('UNANSWERED','ANSWERED')
- username — VARCHAR(255)
- reason — VARCHAR(255)
- is_hide — TINYINT(1)
library
- library_id — INT
- username — VARCHAR(255)
- name — VARCHAR(255)
- is_show — TINYINT(1)
library_book
- librarybook_id — INT
- book_name — VARCHAR(255)
- book_writer — VARCHAR(255)
- book_img — VARCHAR(255)
- library_id — INT
notice
- notice_id — INT
- title — VARCHAR(255)
- content — TEXT
- reg_date — DATETIME
- top_fix — TINYINT(1)
order
- order_id — INT
- username — VARCHAR(255)
- payment_status — ENUM('PENDING','APPROVED','CANCELLED')
- payment_key — VARCHAR(255)
- approved_at — DATETIME
- point_id — INT
- payment_method — ENUM('CARD','BANK','POINT')
- price — INT — NOT NULL
other_place
- other_place_id — INT
- name — VARCHAR(255)
- address — VARCHAR(255)
- phone — VARCHAR(20)
- domain — VARCHAR(255)
- weekday_stime — TIME
- weekday_etime — TIME
- weekend_stime — TIME
- weekend_etime — TIME
- introduce — TEXT
- img — VARCHAR(255)
- fee — INT
- facilities — TEXT
other_place_review
- other_place_review_id — INT
- content — TEXT
- rating — INT
- username — VARCHAR(255)
- reg_time — DATETIME
- other_place_id — INT
- is_hide — TINYINT(1)
place
- place_id — INT
- name — VARCHAR(255)
- location — VARCHAR(255)
- phone — VARCHAR(20)
- introduce — TEXT
- tag1 — VARCHAR(50)
- tag2 — VARCHAR(50)
- tag3 — VARCHAR(50)
- tag4 — VARCHAR(50)
- tag5 — VARCHAR(50)
- tag6 — VARCHAR(50)
- tag7 — VARCHAR(50)
- tag8 — VARCHAR(50)
- tag9 — VARCHAR(50)
- tag10 — VARCHAR(50)
- img1 — VARCHAR(255)
- img2 — VARCHAR(255)
- img3 — VARCHAR(255)
- img4 — VARCHAR(255)
- img5 — VARCHAR(255)
- img6 — VARCHAR(255)
- img7 — VARCHAR(255)
- img8 — VARCHAR(255)
- img9 — VARCHAR(255)
- img10 — VARCHAR(255)
place_like
- like_id — INT
- username — VARCHAR(255)
- date — DATETIME
- place_id — INT
place_review
- place_review_id — INT
- content — TEXT
- rating — INT
- username — VARCHAR(255)
- reg_time — DATETIME
- place_id — INT
- is_hide — TINYINT(1)
place_room
- place_room_id — INT
- place_id — INT
- point — INT
- min_person — INT
- max_person — INT
- name — VARCHAR(255)
- introduce — TEXT
- size — VARCHAR(100)
- has_air_conditioner — TINYINT(1)
- has_heater — TINYINT(1)
- has_wifi — TINYINT(1)
- has_power_outlet — TINYINT(1)
- has_whiteboard — TINYINT(1)
- has_window — TINYINT(1)
- has_tv — TINYINT(1)
- has_projector — TINYINT(1)
- img1 — VARCHAR(255)
- img2 — VARCHAR(255)
- img3 — VARCHAR(255)
- img4 — VARCHAR(255)
- img5 — VARCHAR(255)
- img6 — VARCHAR(255)
- img7 — VARCHAR(255)
- img8 — VARCHAR(255)
- img9 — VARCHAR(255)
- img10 — VARCHAR(255)
place_time
- place_time_id — INT
- place_room_id — INT
- is_weekend — TINYINT(1)
- active — TINYINT(1)
- time — VARCHAR(50)
point
- point_id — INT
- username — VARCHAR(255)
- point — INT
- date — DATETIME
- reason — VARCHAR(255)
report
- report_id — INT
- reporter_id — INT
- reported_id — INT
- reason — VARCHAR(255)
- category — VARCHAR(255)
- category_id — VARCHAR(255)
- reported_at — DATETIME
- status — ENUM('PENDING','RESOLVED','REJECTED')
reservation
- reservation_id — INT
- username — VARCHAR(255)
- place_room_id — INT
- participant_count — INT
- reserver_name — VARCHAR(255)
- reserver_phone — VARCHAR(20)
- request_message — TEXT
- status — ENUM('PENDING','CONFIRMED','CANCELLED')
reservation_date
- reservation_date_id — INT
- reservation_id — INT
reservation_time
- reservation_time_id — INT
- reservation_date_id — INT
- place_time_id — INT
user
- username — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(100)
- birth — DATE
- join_date — DATETIME
- profile_img — VARCHAR(255)
- fcm_token — VARCHAR(255)
- deleted — TINYINT(1)
- withdrawal_reason — TEXT
- withdrawal_date — DATETIME
- is_admin — TINYINT(1)
- lat — INT
- log — INT
- totoal_point — INT
write
- write_id — INT
- title — VARCHAR(255) — NOT NULL
- tag1 — VARCHAR(50)
- tag2 — VARCHAR(50)
- tag3 — VARCHAR(50)
- tag4 — VARCHAR(50)
- tag5 — VARCHAR(50)
- reg_date — DATETIME
- end_date — DATETIME
- content — TEXT
- img — VARCHAR(255)
- username — VARCHAR(255)
- view_cnt — INT
- is_hide — TINYINT(1)
write_comment
- write_comment_id — INT
- content — TEXT
- write_id — INT
- reg_date — DATETIME
- username — VARCHAR(255)
- adopted — TINYINT(1)
- is_secret — TINYINT(1)
- is_hide — TINYINT(1)
write_like
- like_id — INT
- username — VARCHAR(255)
- date — DATETIME
- write_id — INT
write_short
- writeshort_id — INT
- content — TEXT
- color — VARCHAR(20)
- username — VARCHAR(255)
- reg_date — DATETIME
- event_id — INT
- is_hide — TINYINT(1)