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