officefinder

Tables (14)

bookmark

  • bookmark_id — Bigint — Primary key — NOT NULL
  • customer_id — Bigint — Foreign key → customer.customer_id — NOT NULL
  • office_id — Bigint — Foreign key → office.office_id — NOT NULL

chat

  • chat_id — Bigint — Primary key — NOT NULL
  • chatroom_id — Bigint — Foreign key → chatroom.chatroom_id — NOT NULL
  • message — VARCHAR
  • customer_id — Bigint
  • office_owner_id — Bigint

chatroom

  • chatroom_id — Bigint — Primary key — NOT NULL
  • customer_id — Bigint — Foreign key → customer.customer_id — NOT NULL
  • owner_id — Bigint — Foreign key → office_owner.owner_id — NOT NULL
  • room_uid — VARCHAR
  • last_seen_customer — timestamp
  • last_seen_office_owner — timestamp

customer

  • customer_id — Bigint — Primary key — NOT NULL
  • customer_name — VARCHAR
  • customer_email — VARCHAR
  • customer_password — VARCHAR
  • customer_point — Bigint
  • customer_role — VARCHAR
  • profile_image — VARCHAR

customer_notification

  • notification_id — Bigint — Primary key — NOT NULL
  • customer_id — Bigint — Foreign key → customer.customer_id — NOT NULL
  • title — varchar
  • content — varchar
  • notification_type — varchar

lease

  • lease_key — Bigint — Primary key — NOT NULL
  • customer_id — Bigint — Foreign key → customer.customer_id — NOT NULL
  • office_id — Bigint — Foreign key → office.office_id — NOT NULL
  • lease_price — Bigint
  • lease_status — VARCHAR
  • lease_start_time — timestamp
  • lease_end_time — timestamp

office

  • office_id — Bigint — Primary key — NOT NULL
  • owner_id — Bigint — Foreign key → office_owner.owner_id — NOT NULL
  • office_name — VARCHAR
  • lease_fee — Bigint
  • maximum_capacity — Integer
  • max_room_count — Integer
  • review_count — Bigint
  • total_rate — Bigint

office_condition

  • office_condition_id — Bigint — Primary key — NOT NULL
  • office_id — Bigint — Foreign key → office.office_id — NOT NULL
  • air_conditioner_status — Bit
  • cafe_status — Bit
  • printer_status — Bit
  • package_send_service_status — Bit
  • door_lock_status — Bit
  • fax_available_status — Bit
  • heater_status — Bit
  • park_available_status — Bit
  • public_kitchen_status — Bit
  • public_lounge_status — Bit
  • private_locker_status — Bit
  • tv_projector_status — Bit
  • whiteboard_status — Bit
  • wifi_available_status — Bit
  • shower_available_status — Bit
  • storeage_available_status — Bit
  • park_area — Bit

office_location

  • office_location_id — Bigint — Primary key — NOT NULL
  • office_id — Bigint — Foreign key → office.office_id — NOT NULL
  • legion — VARCHAR
  • city — VARCHAR
  • town — VARCHAR
  • detail — VARCHAR
  • address — VARCHAR
  • zipcode — Integer

office_owner

  • owner_id — Bigint — Primary key — NOT NULL
  • owner_email — VARCHAR
  • owner_password — VARCHAR
  • owner_business_number — VARCHAR
  • owner_point — Bigint
  • owner_role — VARCHAR
  • office_owner_profile_image — VARCHAR

office_owner_notification

  • notification_id — Bigint — Primary key — NOT NULL
  • owner_id — Bigint — Foreign key → office_owner.owner_id — NOT NULL
  • title — varchar
  • content — varchar
  • notification_type — varchar

office_picture

  • office_picture_id — Bigint — Primary key — NOT NULL
  • office_id — Bigint — Foreign key → office.office_id — NOT NULL
  • file_name — varchar

point_charge_history

  • charge_id — Bigint — Primary key — NOT NULL
  • customer_id — Bigint — Foreign key → customer.customer_id — NOT NULL
  • charge_amount — Bigint
  • created_at — timestamp

review

  • review_id — Bigint — Primary key — NOT NULL
  • lease_key — Bigint — Foreign key → lease.lease_key — NOT NULL
  • review_rateing (review_rating) — Integer
  • description — VARCHAR