ㅁㄴㅇㄹ
Tables (18)
tb_admin
- admin_id — bigint — Primary key — NOT NULL
- social_id — varchar(255)
- member_role — enum — NOT NULL
- email — varchar(255)
- agency_type — enum
- agency_name — varchar(50)
- agency_name_en — varchar(50)
- registration_number — varchar(30)
- address — varchar(100)
- adress_detail — varchar(100)
- address_en — varchar(100)
- agency_phone_number — varchar(50)
- first_name — varchar(30)
- last_name — varchar(30)
- first_name_en — varchar(100)
- last_name_en — varchar(100)
- phone_number — varchar(50)
- admin_language — List<tb_admin_language>
- main_listing — List<tb_main_listing>
- create_at — date — NOT NULL
- update_at — date — NOT NULL
- state — enum — NOT NULL
tb_admin_language
- admin_id — bigint — Foreign key → tb_admin.admin_id — NOT NULL
- language_type — enum — NOT NULL
tb_agent_comment
- listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
- comment — enum — NOT NULL
tb_basic_furniture
- listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
- option_name — enum — NOT NULL
tb_cart
- cart_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → tb_member.member_id — NOT NULL
- listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
- move_in — date — NOT NULL
- contract_period — int — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- state — enum — NOT NULL
tb_contract_date
- order_id — bigint — Foreign key → tb_order.order_id — NOT NULL
- contract_date — date — NOT NULL
tb_contract_status
- order_id — bigint — Foreign key → tb_order.order_id — NOT NULL
- listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
- contract_status_type — enum — NOT NULL
- member_move_in — date — NOT NULL
- member_contract_period — int — NOT NULL
- member_resident_nums — int — NOT NULL
- status_update_date — date
- contract_date — date
- depositor — varchar(30)
- bank — varchar(30)
- account — varchar(30)
- is_remittance — bool
- reject_reason_type — eunm
- reject_reason — varchar(255)
tb_facility
- listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
- facility — enum — NOT NULL
tb_listing
- listing_id — bigint — Primary key — NOT NULL
- admin_id — bigint — Foreign key → tb_admin.admin_id — NOT NULL
- listing_image_urls — LIST<tb_listing_image_url> — NOT NULL
- room_type — enum — NOT NULL
- area — double — NOT NULL
- agent_comments — LIST<tb_agent_comment>
- address — varchar(255) — NOT NULL
- address_detail — varchar(255) — NOT NULL
- address_en — varchar(255) — NOT NULL
- longitude — double — NOT NULL
- latitude — double — NOT NULL
- near_subway_stations — LIST<tb_near_subway_station> — NOT NULL
- near_university — LIST<tb_near_university>
- room_floor — int — NOT NULL
- total_floor — int — NOT NULL
- is_semi_basement — bool — NOT NULL
- is_rooftop — bool — NOT NULL
- facilities — LIST<tb_facility> — NOT NULL
- heating_type — enum — NOT NULL
- window_direction_type — enum — NOT NULL
- building_front_type — enum — NOT NULL
- basic_furnitures — LIST<tb_basic_furniture> — NOT NULL
- deposit — int — NOT NULL
- monthly_rent — int — NOT NULL
- provisional_deposit — int — NOT NULL
- agency_fee — int
- payment_type — enum — NOT NULL
- maintenance_fee — int — NOT NULL
- rent_excludes — LIST<tb_rent_exclude> — NOT NULL
- move_in_date — date — NOT NULL
- min_contract_period — int — NOT NULL
- resident_nums — int — NOT NULL
- is_visible — bool — NOT NULL
- is_on_sale — bool — NOT NULL
- views — bigint — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- state — enum — NOT NULL
tb_listing_image_url
- listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
- image_url — varchar(255) — NOT NULL
tb_main_listing
- admin_id — bigint — Foreign key → tb_admin.admin_id — NOT NULL
- main_listing_type — enum — NOT NULL
tb_member
- member_id — bigint — Primary key — NOT NULL
- member_role — enum — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- first_name — varchar(100) — NOT NULL
- last_name — varchar(100) — NOT NULL
- gender_type — enum — NOT NULL
- birth — date — NOT NULL
- phone_number — varchar(50) — NOT NULL
- country_code — char(2) — NOT NULL
- nationality — varchar(50) — NOT NULL
- occupation_type — enum — NOT NULL
- visa_type — enum — NOT NULL
- read_notification_at — date — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- state — enum — NOT NULL
tb_near_subway_station
- listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
- subway_station — varchar(30) — NOT NULL
- duration — int — NOT NULL
tb_near_university
- listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
- university_name — enum — NOT NULL
tb_notification
- notification_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → tb_member.member_id — NOT NULL
- notification_type — enum — NOT NULL
- title — varchar(100) — NOT NULL
- description — varchar(255) — NOT NULL
- order_id — bigint
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- state — enum — NOT NULL
tb_order
- order_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → tb_member.member_id — NOT NULL
- order_status_type — enum — NOT NULL
- contract_statuses — LIST<tb_contract_status> — NOT NULL
- email — varchar(255) — NOT NULL
- first_name — varchar(100) — NOT NULL
- last_name — varchar(100) — NOT NULL
- gender — enum — NOT NULL
- birth — date — NOT NULL
- phone_number — varchar(50) — NOT NULL
- country_code — char(2) — NOT NULL
- nationality — varchar(50) — NOT NULL
- occupation_type — enum — NOT NULL
- visa_type — enum — NOT NULL
- passport_number — varchar(30) — NOT NULL
- contract_dates — LIST<tb_contract_date> — NOT NULL
- payment_type — enum — NOT NULL
- sub_total — int — NOT NULL
- commission — int — NOT NULL
- refund — tb_refund
- pay_token — varchar(255) — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- state — enum — NOT NULL
tb_refund
- refund_id — bigint — Primary key — NOT NULL
- order_id — bigint — Foreign key → tb_order.order_id — NOT NULL
- refund_type — enum — NOT NULL
- payment_type — enum — NOT NULL
- adjusted_contract_fee — int — NOT NULL
- adjusted_commission — int — NOT NULL
- refund_amount — int — NOT NULL
- created_at — date — NOT NULL
- updated_at — date — NOT NULL
- INACTIVE — enum — NOT NULL
tb_rent_excludes
- listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
- item_name — enum — NOT NULL